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

147 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
chimbly197459(None) 
chimbley2063131chimbley
chicly16429202chi_cly
chiefly1834102chiefly
childly1644802childly
chilly144113222chi_lly
chimb144813562chimb__
chimbleys2162232chimbleys
chimbs153910302chimb_s
chimla1337592chim_la
chimley1785162chimley
chimney1795482chimney
crumbly16347522crumbly
humbly164010522_humbly
nimbly13388772_nimbly
thimble1435872thimble
achingly1736623achingly
amiably1438303amiably
brambly16296253brambly
calmly1337613calm_ly
capably1639253capably
chally144314293ch_ally
chamber164011063chamber
chambray2043143chambray
chammy18488953cham_my
champy18509613cham_py
charily15310283charily
cheaply1735023cheaply
cheerly15417603cheerly
chicle134312543chi_cle
chicory1735993chicory
chiel104918973chi_el_
chield124610213chi_eld
chiels115115933chi_els
child114516223chi__ld
chile105626893chi__le
chili106218483chi__li
chill105619873chi__ll
chilli114312773chi_lli
chillily1644113chillily
chills114717703chi_lls
chimar133911473chim_ar
chimars144010593chimars
chimblies1845033chimblies
chime125322593chim__e
chimed145814833chim_ed
chimer135517203chim_er
chimera14389273chimera
chimere144010633chimere
chimers144515143chimers
chimes134922573chim_es
chiming153311833chiming
chimlas1437453chimlas
chimleys1883633chimleys
chimneys1883643chimneys
chimp145216473chim__p
chimps155713663chim_ps
chinchy20335523chinchy
chinky185610543chi_nky
chintzy24364223chintzy
chippy18437613chi_ppy
chiral114614413chiral_
chirpily1843773chirpily
chirpy16498913chi_rpy
chisel112111943chisel_
chisels12219103chisels
chital114313883chital_
chitty14329433chi_tty
chivalry1943083chivalry
chivvy20374433chi_vvy
chivy164810363chi__vy
choicely1843823choicely
choirboy1842233choirboy
chubbily2042913chubbily
chubby1844123ch_ubby
chummily2042843chummily
chummy18385893chum_my
cicely1338833c_icely
climb115413593climb__
climbed14336983climbed
climber13449133climber
climbs12498723climb_s
comely134213733c_omely
comply152810383c_omply
criminy14268453criminy
crimple13408693crimple
crimpy15489393crim_py
crinkly16387523crinkly
crisply14426523crisply
crumble133410403crumble
crumby15408113crumb_y
crumply16336093crumply
curably142010773curably
dimly114913483_dim_ly
dimply14339743_dimply
dribbly15274953dribbly
dumbly14399603_dumbly
fimble133611753_fimble
ghibli1243493ghi_bli
glibly1236293gli_bly
grimily1336523grimily
grimly12459933grim_ly
grumbly15355403grumbly
highly1636823_highly
hilly114422163_hi_lly
hiply134113613_hi_ply
homely145313183_homely
homily144712333_homily
hubbly16478413_hubbly
humble133615053_humble
imply124911843__imply
jimply20397483_jimply
limby125714073_limb_y
limply133810033_limply
mumbly15319463_mumbly
nimble103412943_nimble
numbly134410663_numbly
pimply15329213_pimply
pliably14147383pliably
primely1457723primely
primly13439623prim_ly
rumbly134412163_rumbly
scribbly17143623scribbly
shamably18165803shamably
shamble14149263shamble
shily115222013shi__ly
shimmy16306413shim_my
shingly143210813shingly
shinily13268933shinily
simply133010523_simply
slimily1247713slimily
slimly11408903slim_ly
thickly19415573thickly
thimbles1536023thimbles
thinly1238673thi_nly
thirdly1444633thirdly
thistly1395963thistly
timely113410113_timely
trembly1435523trembly
trimly114410893trim_ly
viably14199833_viably
wambly16388663_wambly
whimsey18373893whimsey
whimsy17375223whim_sy
whirly15448863whi_rly
whitely16346473whitely
wimble133211923_wimble

Search took 7 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 Limit1340271476.04622167.9
3Display Results1471470.0502940.0
 (SQL Overall)1786911476.48627550.3
 
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.