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

221 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
chimney179548(None) 
chimley1785161chimley
chimneys1883641chimneys
chimbley2063132chimbley
chimbly1974592chimbly
chime125322592chim_e_
chimed145814832chim_ed
chimer135517202chim_er
chimes134922572chim_es
chimleys1883632chimleys
chine105231722chi_ne_
chined125620062chi_ned
chines115029172chi_nes
chinky185610542chi_nky
chinned134810492chinned
chutney1533822chutney
shinney13368292shinney
whimsey18373892whimsey
whiney155012642whi_ney
blimey13468453blim_ey
cairned1037643cairned
cairny11557823cairn_y
carney115315703c_arney
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chainmen15105263chainmen
chamber164011063chamber
chamfer17399863chamfer
chammy18488953cham_my
champed174111483champed
champer163813413champer
champy18509613cham_py
chancy164010863ch_ancy
channel123910483channel
chantey154112543chantey
chanty145215823ch_anty
charley15118273charley
charnel124010053charnel
chianti1236613chianti
chicane1489553chicane_
chicaned1665873chicaned
chicaner1586073chicaner
chicanery19103053chicanery
chicanes1559373chicanes
chicer134513603chi_cer
chickee183111553chickee
chicken18278983chicken
chicle134312543chicle_
chicles143512503chicles
chicly16429203chi_cly
chicness1535593chicness
chicory1735993chicory
chidden14255223chidden
chide115321013chi_de_
chided135113963chi_ded
chider125116053chi_der
chides124620473chi_des
chief134419483chi__ef
chiefer1536863chiefer
chiefly1834103chiefly
chiel104918973chi__el
chigger1436003chigger
chignon1344623chignon
chigoe1237533chigoe_
chigoes1338353chigoes
childe124711213childe_
childes134211273childes
childly1644803childly
chile105626893chi_le_
chiles115425303chi_les
chilies124218303chilies
chilled133310933chilled
chiller124112183chiller
chilly144113223chi_lly
chimaera1564943chimaera
chimar133911473chim_ar
chimars144010593chimars
chimb144813563chim__b
chimbleys2162233chimbleys
chimbs153910303chim_bs
chimera14389273chimera
chimere144010633chimere
chimeres153511313chimeres
chimers144515143chimers
chiming153311833chiming
chimla1337593chim_la
chimlas1437453chimlas
chimp145216473chim__p
chimps155713663chim_ps
chin96934743chi_n__
china105022483chi_n_a
chinas115119403chi_nas
chinch163911233chi_nch
chinchy20335513chinchy
chink145321593chi_n_k
chinked174011023chinked
chinks155817573chi_nks
chino105823313chi_n_o
chinone12510153chinone_
chinones13510473chinones
chinos115018693chi_nos
chins105631463chi_n_s
chints115117833chi_nts
chintz204212033chi_ntz
chintzy24364223chintzy
chipped174110813chipped
chipper163912583chipper
chippy18437613chi_ppy
chirked173810333chirked
chirker16429323chirker
chirmed15379733chirmed
chirped15379783chirped
chirper14359963chirper
chirpy16498913chi_rpy
chirre114111853chirre_
chirred133612123chirred
chirren12388743chirren
chirres123812253chirres
chisel112111943chi_sel
chitter124112963chitter
chitty14329433chi_tty
chive135117623chi_ve_
chives144317593chi_ves
chivied16368383chivied
chivies153412853chivies
chivvy20374433chi_vvy
chivy164810363chi__vy
chokey184811713ch_okey
chomped17329773chomped
chomper163810073chomper
choosey15459233choosey
chummed17396443chummed
chummy18385893chum_my
chumped17379493chumped
chunky18468273ch_unky
chunnel12395303chunnel
churned13358373churned
churner12298343churner
chutnee1246833chutnee
chutneys1642323chutneys
chyme156512503chym_e_
chymes165912153chym_es
cimex16119133c_im_ex
cine66242943c_i_ne_
cines75239683c_i_nes
climbed14336983climbed
climber13449133climber
clime95720893clim_e_
climes104720003clim_es
cline76428533cli_ne_
clines84926043cli_nes
clingy12659063cli_ngy
cliquey21295693cliquey
cockney1835873cockney
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
coined94523603coi_ned
coiner84323783coi_ner
coney105932883c__oney
crickey18418143crickey
crikey15317783cri_key
crime94822693crim_e_
crimes105521583crim_es
crimine112413473crimine_
criminy14268453criminy
crimmer133310773crimmer
crimped143910763crimped
crimper136510423crimper
crimpy15489393crim_py
hickey185011993_hickey
hinky155618753_hi_nky
hinny115616673_hi_nny
homey135924843_hom_ey
honey115629913_h_oney
hymned1535323_hymned
jitney16304623_jitney
kidney1434763_kidney
limey104721043_lim_ey
limned94811473_limned
limner84112873_limner
liney87029633_li_ney
phoney143612983ph_oney
piney105727503_pi_ney
sheeney13398933sheeney
shimmed15338583shimmed
shimmer143310873shimmer
shimmery18265253shimmery
shimmy16306413shim_my
shindy13449323shi_ndy
shine85533093shi_ne_
shined104620783shi_ned
shiner93820873shi_ner
shines95028913shi_nes
shinned114310913shinned
shinnery14305673shinnery
shinneys14275093shinneys
shinny124810783shi_nny
shiny115122143shi_n_y
simnel857023_simnel
spinney12438923spinney
swinney13365973swinney
thine85026863thi_ne_
thinly1238673thi_nly
thinned11399163thinned
thinner10358973thinner
thymey17426313thym_ey
whimper17297723whimper
whimseys19322463whimseys
whimsy17375223whim_sy
whine116022813whi_ne_
whined134715203whi_ned
whiner124516633whi_ner
whines125120103whi_nes
whinny15587493whi_nny
whiny144915573whi_n_y
whiskey20445583whiskey
whitey154911883whi_tey
winey115325433_wi_ney
witney12356843_witney

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272216.54620474.6
3Display Results2212210.0633507.9
 (SQL Overall)1786912216.99925530.9
 
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.