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 “canalised” 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.

104 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
canalised1281091(None) 
canalise10816211canalise_
canalises11515491canalises
canalized21611691canalized
analysed12166912_analysed
banalized21118702banalized
canaled103615562canal__ed
canalize19914492canalize_
canalizes201113782canalizes
canalled1139582canal_led
canonised1256712canonised
finalised13338012finalised
nasalised1045912nasalised
penalised12108832penalised
scandalised1553522scandalised
tantalised11126982tantalised
vandalised1545152vandalised
alkalised14155263alkalised
anaclises1147863_anaclises
analyse10208893_analyse_
analyser11166133_analyser
analyses11149963_analyses
analyzed21155703_analyzed
banalize191010933banalize_
banalizes201210093banalizes
cabalism14310143cabalis_m
cabalisms1548433cabalisms
cabalist12314503cabalis_t
cabalists1339153cabalists
caballed1337163cabal_led
caddised13315893ca_ddised
calamined1447433calamined
callused1135853ca_llused
camailed1336553cama_iled
canaille1048413canaille_
canailles1148273canailles
canaling112016413canali_ng
canalising1349363canalising
canaller1038953canal_ler
canals84421663canal_s__
canaries10318943canari_es
candied113816023can_di_ed
candled113815743candl__ed
cannabises1444433cannabises
cannibalised17142263cannibalised
canonise10511093canonise_
canonises11410803canonises
canonized2147683canonized
canopied1336343canopi_ed
canulated12310673canulated
canvased14246213can_vased
canvassed15274033canvassed
capitalised1684853capitalised
caramelised1673093caramelised
cartelised1344913cartelised
catalase1039213catalase_
catalases1149433catalases
cataloged1365303cataloged
catalyses1447433catalyses
catalyzed2444993catalyzed
cavalier1348173cavali_er
cavaliered1642653cavaliered
centralised1446603centralised
chaliced1637043c_haliced
civilised1584613civilised
creolised1255203creolised
equalised1945473equalised
fantasised14104343fantasised
faradised14235913faradised
finalise113112573finalise_
finalises122911523finalises
finalized22279243finalized
focalised15156953focalised
idealised1145673idealised
legalised1145843legalised
localised12167863localised
metalised12310463metalised
moralised1239663moralised
nasalise848863nasalise_
nasalises948113nasalises
nasalized1946753nasalized
paganised1346623paganised
panelized2147033panelized
paralysed1545743paralysed
penalise101013763penalise_
penalises11912773penalises
penalized211210243penalized
realised92214533_realised
recanalized2346673recanalized
ruralised1046593ruralised
sanitised10147353sanitised
scandalise1344893scandalise_
scandalises1444803scandalises
scandalized2454053scandalized
signalised1244243signalised
tantalise91210823tantalise_
tantalises101010103tantalises
tantalized20118923tantalized
totalised1048073totalised
vandalise1347673vandalise_
vandalises1446813vandalises
vandalized2445813vandalized
vitalised1347203vitalised
vocalised15157393vocalised

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.436409841.7
2DLD Change Limit1486411047.56319653.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.