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

197 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
canalise1081621(None) 
canalised12810911canalised
canalises11515491canalises
canalize19914491canalize
analyse10208892_analyse
banalize191010932banalize
cabalism14310142cabalism
cabalist12314492cabalist
canaille1048412canaille
canaling112016402canaling
canalized21611692canalized
canalizes201113782canalizes
canals84421662canal_s_
canaries10318942canaries
canonise10511092canonise
catalase1039212catalase
finalise113112572finalise
nasalise848862nasalise
penalise101013762penalise
scandalise1344892scandalise
tantalise91210812tantalise
vandalise1347672vandalise
alkalise12178043alkalise
anaclises1147863_anaclises
analcime1245393_analcime
analcite1049333_analcite
anality10313633_anality
analysed12166913_analysed
analyser11166133_analyser
analyses11149963_analyses
analyst10189323_analyst
analyte10158813_analyte
analyze19167013_analyze
anatase738943_anatase
anglice1089213_anglice
aniline7418473_aniline
anise55129703_an__ise
annalist8413753annalist
antlike11312073_antlike
anywise1345203_anywise
baalism11310593ba_alism
banality1338763banality
banalized21118703banalized
banalizes201210093banalizes
cabalas113516003cabalas_
cabalisms1548433cabalisms
cabalists1339143cabalists
cabals104020153cabal_s_
cabbalism1745683cabbalism
cabbalist1547643cabbalist
cagelike1537723cagelike
calamine12314023calamine
calamite12312533calamite
calflike1735153calflike
callose9313653ca_llose
camails11311743camails_
camise103319633c__amise
canailles1148263canailles
canakin131810833canaki_n
canakins142010463canakins
canal75428043canal___
canaled103615553canal_ed
canalising1349353canalising
canalled1139573canalled
canaller1038953canaller
canalling1239543canalling
canape10913513cana__pe
canapes111213083canapes_
canards10311203canards_
candies104125613can_dies
candle94321483candl__e
candles104422343candles_
candling122313873candling
canine83826703can__ine
canities101519243canities
cannabis1266033cannabis_
cannabises1444433cannabises
cannibalise15153223cannibalise
cannie83819363can_ni_e
cannolis1037863cannolis_
canoeist10310693canoeist
canolas9313993canolas_
canonised1256713canonised
canonises11410803canonises
canonist10513533canonist
canonize1959833canonize
canopies12311853canopies
cantabile1346893cantabile
cantalas104013523cantalas_
cantals93919573cantal_s_
cantle84522153cantl__e
cantles94721413cantles_
canulae9311183canul_ae
canulas9312853canulas_
canulate10314553canulate
canvaslike1951883canvaslike
capitalise1466713capitalise
carabine12412383carabine
caramelise1464683caramelise
carline93923613ca_rline
carlish12312763ca_rlish
carnality1447593carnality
carnallite1244123carnallite
cartelise1148113cartelise
catalases1149433catalases
cataloes10311643cataloes
catalos9414163catalos_
catalyses1447433catalyses
catalyst1347313catalyst
catalyze2245623catalyze
catamite12510593catamite
catlike132712933ca_tlike
cauline92215603ca_uline
caulis85320073ca_ulis_
cavalier1348173cavalier
cavallies1446383cavallies
cavalries1446363cavalries
cavatine13310323cavatine
cavelike1738213cavelike
centralise1269593centralise
chaise114916413c_ha_ise
chalice14311043c_halice
chamise143612853c_hamise
civilise1386253civilise
conative131214623conative
concise11314473con_cise
creolise1037863creolise
cyanamide1743343cyanamide
equalise1748213equalise
fanglike1636823fanglike
fanlike142610503fan_like
fantasise1296243fantasise
fanwise1336633fan_wise
faradise12219393faradise
fatalism13310483fatalism
fatalist11314973fatalist
fayalite1447053fayalite
finalis103313653finalis_
finalised13338013finalised
finalises122911523finalises
finalism133010363finalism
finalist113014733finalist
finalize202711023finalize
focalise131210373focalise
gantline9410903gantline
handlike1639153handlike
handlist12311333handlist
idealise938053idealise
kabalism1647043kabalism
kabalist14410083kabalist
lanais6316793lana_is_
landline9311443landline
lanoline8311943lanoline
lavalike1536283lavalike
legalise949493legalise
localise101511853localise
malaise9312673mala_ise
manlike133012783man_like
manwise1239183man_wise
metalise10416053metalise
moralise10314913moralise
nasalised1045903nasalised
nasalises948113nasalises
nasalism1048203nasalism
nasalize1748183nasalize
paganise1139663paganise
panelist10414503panelist
paradise112113873paradise
paralyse1347483paralyse
penalised12108823penalised
penalises11912753penalises
penalize19912753penalize
realise73021813_realise
recanalize2147243recanalize
ruralise839643ruralise
sanative11310473sanative
sandlike1339713sandlike
sanitise81511813sanitise
scandalised1553523scandalised
scandalises1444803scandalises
scandalize2244613scandalize
signalise1046393signalise
tanklike1136013tanklike
tantalised11126973tantalised
tantalises101010073tantalises
tantalite91010853tantalite
tantalize181010563tantalize
totalise8312503totalise
unalike11311533_unalike
valise92917643__valise
vandalised1545153vandalised
vandalises1446813vandalises
vandalish1645993vandalish
vandalism1546873vandalism
vandalize2246793vandalize
vitalise11310743vitalise
vocalise131510813vocalise

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621978.39017421.0
3Display Results1971970.0932118.3
 (SQL Overall)1786911978.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.