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 “clime” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
clime9572089(None) 
chime125322591chime
climb115413591climb
climes104720001climes
cline76428531cline
crime94822691crime
glime85620191glime
lime66244931_lime
slime74925751slime
alike95523962alike
aline57243152aline
alive85722512alive
alme65832162al_me
anime75423202anime
blame95625492blame
blimey13468452blimey
blimp115612942blimp
blimy125212822blimy
blite76225352blite
blume95619892blume
came87648752c_ame
chide115321012chide
chile105626892chile
chimb144813562chimb
chimed145814832chimed
chimer135517202chimer
chimes134922572chimes
chimp145216472chimp
chine105231722chine
chive135117622chive
chyme156512502chyme
cilice103213352cilice
cimex16119132c_imex
cine66242942c_ine
cire65836372c_ire
cite65640342c_ite
clade85821012clade
claim95616912claim_
claimed12298832claimed
claimer11279882claimer
claims105211572claims
clam86332292clam_
clamp115517652clamp
clams95127672clams
clave105420152clave
cleome1039082cleome
clepe94617382clepe
cliche133712452cliche
click135217952click
cliff135917132cliff
clift106422192clift
climate11312832climate
climax1735652climax
climbed14336982climbed
climber13449132climber
climbs12498722climbs
clines84926042clines
cling86424672cling
clink115320042clink
clip86924002cli_p
clips96018302clips
clipt96324272clipt
clique17289192clique
clomb115714702clomb
clomp115615702clomp
clone75728162clone
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532cl_ue
clump115517452clump
come87547702c_ome
creme94319322creme
crimes105521582crimes
crimp115615802crimp
cripe95521142cripe
cyme119420372c_yme
delime9314042delime
dime76237642_dime
elide64922642elide
elite56230182elite
flame105124442flame
flite85424962flite
flume106021172flume
glide74521592glide
glim76026352glim_
glimed105312282glimed
glimes94717522glimes
glims87417672glims
glume85120462glume
grime85021322grime
lame66849292_lame
lice66045062_lice
lie38264522_li_e
life75433732_life
like86040842_like
lima65734132_lima
limb85429382_limb
limed85426802_limed
limen75426032_limen
limes75636502_limes
limey104721042_limey
limn66527692_limn
limo65529732_limo
limp88432492_limp
limy95727712_limy
line46965572_line
lipe66839732_lipe
lire47845292_lire
lite47054542_lite
live76540992_live
mime85736402_mime
olive84817152olive
oxime1498432oxime
plie65127392pli_e
plume94819462plume
prime96525602prime
rime65138882_rime
slice74925822slice
slide64725412slide
slim66631962slim_
slimed94915122slimed
slimes84722042slimes
slims75423652slims
slimy105417422slimy
slipe75626132slipe
stime76521802stime
time66235012_time

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001281.65632487.9
3Display Results1281280.0462782.6
 (SQL Overall)1786911282.02888111.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.