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

184 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
simps9471976(None) 
gimps105915201gimps
imps86221121_imps
limps95522671limps
pimps114616981pimps
samps96124671samps
simas75727551simas
simp85228771simp_
sims65737171sim_s
sips65740101si_ps
skimps14488041skimps
sumps95023431sumps
wimps125213801wimps
aims67738182aim_s
amps86230342_amps
bimas95521742bimas
blimps12588152blimps
bumps115921142bumps
camps116330262camps
chimps155713662chimps
comps115526052comps
crimps124613452crimps
damps105220412damps
dimes85833042dimes
dims75435022dim_s
dips75536912di_ps
dumps105220102dumps
gamps105323712gamps
gimp96124042gimp_
gimpy135212232gimpy
gips75632922gi_ps
hemps126917332hemps
hims95230972him_s
hips96433702hi_ps
humps126322802humps
imp76626972_imp_
impi85415792_impi
impis96213852_impis
isms66213472ism_s
jimp155618462jimp_
jimpy195210822jimpy
jumps165116492jumps
kemps135012522kemps
kips106430522ki_ps
lamps95624832lamps
limas75627632limas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limp88432492limp_
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
lips67141442li_ps
lisps76913912lisps
lumps95624982lumps
mimes95732022mimes
mips85534082mi_ps
mumps115619102mumps
nims66226882nim_s
nips65830922ni_ps
pimas94725102pimas
pimp106024902pimp_
pips85837132pi_ps
pomps115316192pomps
primps124711822primps
pumps115520602pumps
ramps96224632ramps
rimes75634542rimes
rims65936302rim_s
rips66237432ri_ps
romps94617542romps
rumps95922292rumps
salps74423242salps
samp85733592samp_
saps65346372s_aps
scamps125014172scamps
scops95820192scops
scrimps13517902scrimps
scups95316652scups
seeps74828752seeps
semes75731582semes
semis74623532semis
shims104422552shim_s
ships105123772ships
shops104222902shops
shrimps14516752shrimps
sials54227242sials
sibbs96211902sibbs
sibs65933542si_bs
sices75637272sices
sicks115127622sicks
sics65234092si_cs
sides65838362sides
sifts84918922sifts
sighs95416742sighs
sigmas94111362sigmas
signs65516322signs
sikas94617022sikas
sikes96236082sikes
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
sim56553142sim__
sima64730782sim_a
simar74920812simar
simars84916932simars
simper103616292simper
simpers113014122simpers
simple104315172simple
simples113014942simples
simply133010522simply
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272si_ns
sinus55523852sinus
sip57656012si_p_
sipe67341042si_pe
sipes76036952sipes
sires55945372sires
sirs44338332si_rs
sirups83710532sirups
sis37360542si__s
sises55233832sises
sites56045432sites
sits45050202si_ts
situps8538782situps
situs55019232situs
sixes124526362sixes
sixmos1534812sixmos
sizes146727762sizes
skeps115614252skeps
skimos12548802skimos
skimp135411322skimp_
skimpy17475722skimpy
skims114517192skim_s
skips115616602skips
slaps76025712slaps
slimes84722042slimes
slimpsy1463332slimpsy
slims75423652slim_s
slips76023722slips
slops75026012slops
slumps104313582slumps
snaps74719562snaps
snips75818012snips
soaps75120712soaps
somas76030372somas
soms66239372som_s
sops65244562s_ops
soups75322942soups
stamps105614022stamps
steps76619882steps
stimes85920572stimes
stirps85011822stirps
stomps105612832stomps
stops74827282stops
stumps104912282stumps
sumos75720092sumos
sump86331532sump_
sums65837582sum_s
sups64834432s_ups
swamps135910262swamps
swaps104819202swaps
swims105514142swim_s
swops105913972swops
tamps95524082tamps
temps95417132temps
times75630822times
tips66436762ti_ps
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
vims95423312vim_s
wimp115521522wimp_
wimpy155911922wimpy
wisps105214182wisps
yips95226702yi_ps
zips155723792zi_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.343520965.0
2DLD Change Limit538001841.70331591.3
3Display Results1841840.0603066.7
 (SQL Overall)1786911842.10684848.5
 
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.