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

177 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
canalises1151549(None) 
canalise10816211canalise_
canalised12810911canalised
canalizes201113781canalizes
anaclises1147862_anaclises
analyses11149962_analyses
banalizes201210092banalizes
cabalisms1548432cabalisms
cabalists1339152cabalists
canailles1148272canailles
canalize19914492canalize_
canalized21611692canalized
canaries10318942canari_es
cannabises1444432cannabises
canonises11410802canonises
catalases1149432catalases
catalyses1447432catalyses
finalises122911522finalises
nasalises948112nasalises
penalises11912772penalises
scandalises1444802scandalises
tantalises101010102tantalises
vandalises1446812vandalises
abatises10311013_abatises
alkalises13167483alkalises
anabases1038083_anabases
anabioses1145403_anabioses
anaclisis1146043_anaclisis
analcimes1344323_analcimes
analcites1147483_analcites
analities9715873_analities
analyse10208893_analyse_
analysed12166913_analysed
analyser11166133_analyser
analysers12124603_analysers
analysis11128293_analysis
analysts11167443_analysts
analytes11169203_analytes
analyzes20157193_analyzes
anatases839793_anatases
anilines8415143_anilines
anises64826693_an__ises
anlases72514903_an_lases
annalists949063annalists
baalisms1238033ba_alisms
banalities1249813banalities
banalize191010933banalize_
banalized21118703banalized
bubalises1346323bubalises
cabalism14310143cabalis_m
cabalist12314503cabalis_t
cabbalisms1844523cabbalisms
cabbalists1644723cabbalists
caddises12329353ca_ddises
calamines13312223calamines
calamites13410713calamites
calices114321693c__alices
calloses10313393ca_lloses
calluses1039323ca_lluses
camases114216343cama__ses
camasses12388973cama_sses
camises114218463c__amises
canaille1048413canaille_
canakins142010463canaki_ns
canaled103615563canal__ed
canaling112016413canali_ng
canalising1349363canalising
canalled1139583canal_led
canaller1038953canal_ler
canallers1137213canallers
canals84421663canal___s
canapes111213083cana__pes
candies104125613can_di_es
candles104422343candl__es
canines93724033can__ines
canities101519263caniti_es
cannibalises16143033cannibalises
canoeists1147163canoeists
canonise10511093canonise_
canonised1256713canonised
canonists1158513canonists
canonizes2049593canonizes
canopies12311853canopi_es
cantabiles1445763cantabiles
cantles94721413cantl__es
canulates11312873canulates
canvases13349513can_vases
canvasses14286033canvasses
capitalises1586273capitalises
carabines13311463carabines
caramelises1554613caramelises
carlines103521643ca_rlines
carnalities1348773carnalities
carnallites1353043carnallites
caroluses1157613caroluses
cartelises1247683cartelises
cassises103811743ca_ssises
catalase1039213catalase_
catalexes1845913catalexes
cataloes10311653catal_oes
catalysis1445873catalysis
catalysts1445513catalysts
catalyzes2346053catalyzes
catamites1349363catamites
cavalier1348173cavali_er
cavaliers1455613cavaliers
cavallies1446393cavallies
cavalries1446363cavalries
centralises1349293centralises
chaises124317493c_ha_ises
chalices15310813c_halices
challises14358783challises
chamises153513313c_hamises
civilises14106093civilises
creolises1157893creolises
cullises103111313c_ullises
cyanamides1842953cyanamides
equalises1847253equalises
fantasises1395883fantasises
faradises13248983faradises
fatalisms1439113fatalisms
fatalists12310023fatalists
fayalites1546063fayalites
finalise113112573finalise_
finalised13338013finalised
finalisms14318833finalisms
finalists123010163finalists
finalizes212810743finalizes
focalises14139953focalises
gantlines1039333gantlines
handlists1347133handlists
idealises1047783idealises
kabalisms1745953kabalisms
kabalists1546293kabalists
landlines1039763landlines
lanolines939983lanolines
legalises1038563legalises
localises111411463localises
malaises10312333mala_ises
mantises10317923man_tises
metalises11315073metalises
moralises11314003moralises
nasalise848863nasalise_
nasalised1045913nasalised
nasalisms1147173nasalisms
nasalizes1847233nasalizes
oxalises1538503_oxalises
paganises1239723paganises
panelists1148343panelists
paradises122513203paradises
paralyses1448283paralyses
penalise101013763penalise_
penalised12108833penalised
penalizes20911853penalizes
realises82420183_realises
reanalyses1343503reanalyses
recanalizes2247043recanalizes
ruralises939123ruralises
sanitises91111743sanitises
scandalise1344893scandalise_
scandalised1553523scandalised
scandalizes2344533scandalizes
signalises1145913signalises
tallises82713263ta_llises
tantalise91210823tantalise_
tantalised11126983tantalised
tantalites1099283tantalites
tantalizes19109943tantalizes
tantaluses10104593tantaluses
totalises9311783totalises
valises103516263__valises
vandalise1347673vandalise_
vandalised1545153vandalised
vandalisms1645803vandalisms
vandalizes2346463vandalizes
vitalises12310093vitalises
vocalises141710333vocalises

Search took 8 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 Limit1486411776.95321378.0
3Display Results1771770.0802212.5
 (SQL Overall)1786911777.45323975.7
 
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.