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

186 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
limps9552267(None) 
blimps12588151blimps
gimps105915201gimps
imps86221121_imps
lamps95624831lamps
limas75627631limas
limbs96118941limbs
limes75636501limes
limns75718391limns
limos75320811limos
limp88432491limp_
limpa97014461limpa
limpas105513081limpas
limpsy13516841limpsy
lips67141441li_ps
lisps76913901lisps
lumps95624981lumps
pimps114616981pimps
simps94719761simps
wimps125213801wimps
aims67738182aim_s
amps86230342_amps
bimas95521742bimas
blimp115612942blimp_
blips95615782bli_ps
bumps115921142bumps
camps116330262camps
chimps155713662chimps
clamps124515082clamps
climbs12498722climbs
climes104720002climes
clips96018302cli_ps
clomps125212232clomps
clumps1215314642clumps
comps115526052comps
crimps124613452crimps
damps105220412damps
dimes85833042dimes
dims75435022dim_s
dips75536912di_ps
dumps105220102dumps
flips105117742fli_ps
flumps135112502flumps
gamps105323712gamps
gimp96124042gimp_
gimpy135212232gimpy
gips75632922gi_ps
glimes94717522glimes
glimpse1233762glimpse
glims87417672glim_s
hemps126917332hemps
hims95230972him_s
hips96433702hi_ps
humps126322802humps
imp76626972_imp_
impi85415792_impi
impis96213852_impis
jimp155618462jimp_
jimpy195210822jimpy
jumps165116492jumps
kemps135012522kemps
kips106430512ki_ps
lamas75532792lamas
lambs95921412lambs
lames75445542lames
lamp86233822lamp_
lampas106615952lampas
lams66552262lam_s
laps66848872l_aps
leaps75522932leaps
liars54723162liars
libs66732762li_bs
licks115325392licks
lidos65219882lidos
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
lilos55821872lilos
lilts55822802lilts
lima65734132lim_a
liman75921602liman
limans84816302limans
limb85429382lim_b
limba95414982limba
limbas105313202limbas
limbi96513812limbi
limbo95614812limbo
limbos104712142limbos
limbus105710382limbus
limby125714072limby
lime66244932lim_e
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limit73126342limit
limits82514142limits
limn66527692lim_n
limo65529732lim_o
limped114817122limped
limper104117852limper
limpers113815222limpers
limpest113712312limpest
limpet103518632limpet
limpets11329782limpets
limpid11389752limpid
limply133810032limply
limpsey14365092limpsey
limy95727712lim_y
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lip514755802li_p_
lipa68425922li_pa
lipe66839732li_pe
lippy124511902lippy
liras56021982liras
lis37162272li__s
lisp68926872lisp_
lists56628692lists
litas54923772litas
litmus836322litmus
lits46252492li_ts
lives86133192lives
loops75723962loops
lops66043352l_ops
loups75319622loups
lumas75622912lumas
lump86531702lump_
lumpy126615912lumpy
lums65734242lum_s
lymph1547042lymph
lymphs1635052lymphs
mimes95732022mimes
mips85534082mi_ps
mumps115619102mumps
nims66226882nim_s
nips65830922ni_ps
pimas94725102pimas
pimp106024902pimp_
pips85837132pi_ps
plumps124612612plumps
pomps115316192pomps
primps124711822primps
pumps115520602pumps
ramps96224632ramps
rimes75634542rimes
rims65936302rim_s
rips66237432ri_ps
romps94617542romps
rumps95922292rumps
samps96124672samps
simas75727552simas
simp85228772simp_
sims65737172sim_s
sips65740102si_ps
skimps14488042skimps
slimes84722042slimes
slimpsy1463332slimpsy
slims75423652slim_s
slips76023722sli_ps
slumps104313582slumps
sumps95023432sumps
tamps95524082tamps
temps95417132temps
times75630822times
tips66436762ti_ps
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
vims95423312vim_s
wimp115521522wimp_
wimpy155911922wimpy
wisps105214182wisps
yips95226692yi_ps
zips155723792zi_ps

Search took 6 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.283631417.0
2DLD Change Limit538001864.67011520.3
3Display Results1861860.0632952.4
 (SQL Overall)1786911865.01635624.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.