Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “canalized” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
canalized2161169(None) 
banalized21118701banalized
canalised12810911canalised
canalize19914491canalize_
canalizes201113781canalizes
analyzed21155702_analyzed
banalize191010932banalize_
banalizes201210092banalizes
canaled103615562canal__ed
canalise10816212canalise_
canalises11515492canalises
canalled1139582canal_led
canonized2147682canonized
catalyzed2444992catalyzed
finalized22279242finalized
nasalized1946752nasalized
panelized2147042panelized
penalized211210242penalized
recanalized2346672recanalized
scandalized2454052scandalized
tantalized20118922tantalized
vandalized2445812vandalized
actualized2245343actualized
agatized1947073_agatized
alkalized23146603alkalized
analogized21155153_analogized
analysed12166913_analysed
analyze19167013_analyze_
analyzer20155053_analyzer
analyzes20157193_analyzes
animalized2247013_animalized
annualized2044613annualized
anodized1946463_anodized
arabized2047173_arabized
caballed1337163cabal_led
calamined1447433calamined
calorized21249673calorized
camailed1336553cama_iled
canaille1048413canaille_
canailles1148283canailles
canaling112016413canali_ng
canalizing22410423canalizing
canaller1038953canal_ler
canaries10318943canari_es
candied113816023can_di_ed
candled113815743candl__ed
cannibalized26142973cannibalized
canonised1256713canonised
canonize1959833canonize_
canonizer2046693canonizer
canonizes2049593canonizes
canopied1336353canopi_ed
canulated12310673canulated
capitalized2556473capitalized
caponized2347073caponized
capsized2255503ca_psized
capsulized2482953capsulized
caramelized2573323caramelized
carbolized24177083carbolized
cartelized2246183cartelized
catabolized25113903catabolized
cataloged1365303cataloged
catalyze2245623catalyze_
catalyzer2344453catalyzer
catalyzes2346053catalyzes
cavalier1348183cavali_er
cavaliered1642663cavaliered
centralized2348153centralized
chaliced1637043c_haliced
channelized2652603channelized
civilized24105493civilized
creolized2145643creolized
curarized2176403curarized
cyclized2544943c_yclized
dualized1937403_dualized
equalized2846863equalized
fantasized2385123fantasized
faradized23216313faradized
finalised13338013finalised
finalize202711023finalize_
finalizer21307923finalizer
finalizes212810743finalizes
focalized24157963focalized
idealized2046653idealized
japanized2844733japanized
labialized2245403labialized
legalized2047523legalized
localized21168833localized
metalized21412183metalized
moralized21310753moralized
nasalised1045913nasalised
nasalize1748183nasalize_
nasalizes1847233nasalizes
paganized2247163paganized
paralyzed2445303paralyzed
penalised12108833penalised
penalize19912753penalize_
penalizes20911853penalizes
racialized2247683racialized
realized182514223_realized
reanalyzed2352933reanalyzed
recanalize2147253recanalize_
recanalizes2247043recanalizes
ruralized1947903ruralized
sacralized2246983sacralized
sanitized19138173sanitized
scandalised1553523scandalised
scandalize2244613scandalize_
scandalizes2344533scandalizes
signalized2145733signalized
tantalised11126983tantalised
tantalize181010573tantalize_
tantalizer19107283tantalizer
tantalizes19109943tantalizes
totalized1949453totalized
unanalyzed2342493unanalyzed
vandalised1545153vandalised
vandalize2246793vandalize_
vandalizes2346463vandalizes
vernalized2348423vernalized
vitalized2239113vitalized
vocalized24178813vocalized

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.420425454.8
2DLD Change Limit1486411228.12618292.0
3Display Results1221220.0631936.5
 (SQL Overall)1786911228.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.