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

123 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
kemps13501252(None) 
hemps126917331hemps
keeps116020281keeps
kelps115116421kelps
kemp126418761kemp_
kempt134318461kempt
keps106027301ke_ps
temps95417131temps
amps86230342_amps
beeps95320972beeps
bemas96424282bemas
bumps115921142bumps
camps116330262camps
ceps86125952ce_ps
comps115526052comps
damps105220412damps
deeps84921772deeps
demes86032692demes
demos86022992demos
dumps105220102dumps
emes65434662_emes
ems56435492_em_s
emus66821682_emus
femes105626222femes
fems96428702fem_s
gamps105323712gamps
gems75329112gem_s
gimps105915202gimps
heaps105223222heaps
helps105219342helps
hemes105031082hemes
hemp115725622hemp_
hempy154912762hempy
hems95534942hem_s
humps126322802humps
imps86221122_imps
jeeps144715372jeeps
jumps165116492jumps
kames115024692kames
keas86337092ke_as
kecks105416572kecks
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keep106329822keep_
keets95123482keets
kefs115922742ke_fs
kegs95824022ke_gs
keirs95313672keirs
keleps12478812keleps
kelp105322802kelp_
kelpy145110682kelpy
kelts95222632kelts
kenos95220622kenos
kens85435232ke_ns
kep96437202ke_p_
kepi105315632ke_pi
kepis115313362kepis
kept106232942ke_pt
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616132kermes
kermis124012392kermis
kerns94719562kerns
kexes166216822kexes
keys116322162ke_ys
kips106430522k_ips
knaps115511172knaps
knops115911812knops
kops107031292k_ops
kreeps12427412kreeps
kumys1435932kumys
lamps95624832lamps
leaps75522932leaps
limps95522672limps
lumps95624982lumps
memes94927702memes
memos95719112memos
mems85931502mem_s
mumps115619102mumps
neaps75618322neaps
neeps75617882neeps
nemas75321572nemas
peeps95822362peeps
peps85134512pe_ps
perps95521482perps
pimps114616982pimps
pomps115316192pomps
pumps115520602pumps
ramps96224632ramps
reaps75626192reaps
remaps105012872remaps
rems66237722rem_s
repps95114342repps
reps65937952re_ps
romps94617542romps
rumps95922292rumps
samps96124672samps
seeps74828752seeps
semes75731582semes
semis74623532semis
simps94719762simps
skelps12407922skelps
skeps115614252ske_ps
skimps14488042skimps
sumps95023432sumps
tamps95524092tamps
temp85323332temp_
tempi94912202tempi
tempo95214972tempo
tempos103812292tempos
tempt95124842tempt
tempts10439452tempts
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
veeps104715722veeps
weeps104120562weeps
wimps125213802wimps
yelps105712992yelps
yeps95924402ye_ps
zeps156019342ze_ps

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.516346300.4
2DLD Change Limit538001231.62333148.5
3Display Results1231230.0333727.3
 (SQL Overall)1786911232.17282270.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.