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 “imps” 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
imps8622111(None) 
amps86230341amps
gimps105915201gimps
imp76626961imp_
impi85415771impi
impis96213831impis
limps95522671limps
mips85534071mips
pimps114616981pimps
simps94719761simps
umps85721941umps
wimps125213801wimps
aims67738182aim_s
alps65529242alps
amas67746292amas
amis66445312amis
amp77541022amp_
amus65529612amus
apps86319692apps
asps65622092asps
baps86040842baps
bimas95521742bimas
blimps12588152blimps
bops86037982bops
bumps115921142bumps
camps116330262camps
caps87147892caps
ceps86125952ceps
chimps155713662chimps
comps115526052comps
cops86751372cops
crimps124613452crimps
cups85430822cups
damps105220412damps
daps77239162daps
dimes85833042dimes
dims75435022dim_s
dips75536912dips
dumps105220102dumps
dups75929512dups
emes65434662emes
ems56435492em_s
emus66821682emus
fops96532682fops
gamps105323712gamps
gaps76042972gaps
gimp96124042gimp_
gimpy135212232gimpy
gips75632922gips
gyps105115022gyps
haps96443462haps
hemps126917332hemps
hims95230972him_s
hips96433702hips
hops97942632hops
humps126322802humps
hyps125418412hyps
iambs95815052iambs
ibis66519562ibis
ices66129642ices
ichs96214712ichs
ides57734232ides
ids47535462i_ds
ifs67124242i_fs
iggs66612672iggs
ilks87218572ilks
ills47030422ills
imam81718322imam
imams91511102imams
imid76122272imid
imids86015122imids
immy114611822immy
imped105117972imped
impel95711762impel
impels10389512impels
impish13499172impish
imply124911832imply
impose103113042impose
impost103011772impost
inks86926502inks
inns46920932inns
ins35945602i_ns
ions46737852ions
ires45639282ires
iris45732542iris
irks86220132irks
is27048212i__s
isms66213472isms
its35538832i_ts
iwis77117002iwis
jimp155618462jimp_
jimpy195210822jimpy
jumps165116492jumps
kemps135012522kemps
keps106027302keps
kips106430512kips
kops107031292kops
lamps95624832lamps
laps66848872laps
limas75627632limas
limbs96118932limbs
limes75636502limes
limns75718392limns
limos75320812limos
limp88432492limp_
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
lips67141442lips
lisps76913902lisps
lops66043352lops
lumps95624982lumps
maps86141042maps
mas58175812_mas
mibs85330462mibs
mics87435142mics
mids76541772mids
migs76935312migs
mils66045322mils
mimes95732022mimes
mirs66940562mirs
mis58162612_mis
miss65339412miss
mops85940132mops
mos57067122_mos
mumps115619102mumps
mus55946752_mus
naps66238582naps
nims66226882nim_s
nips65830922nips
oms56337512om_s
oops65232672oops
ops56641252_ops
paps86443452paps
peps85134512peps
pimas94725102pimas
pimp106024902pimp_
pips85837132pips
pomps115316192pomps
pops86340952pops
primps124711822primps
pumps115520602pumps
pups86032232pups
ramps96224632ramps
raps66247732raps
reps65937952reps
rimes75634542rimes
rims65936302rim_s
rips66237432rips
romps94617542romps
rumps95922292rumps
samps96124672samps
saps65346372saps
simas75727552simas
simp85228772simp_
sims65737172sim_s
sips65740102sips
skimps14488042skimps
sops65244562sops
sumps95023432sumps
sups64834432sups
tamps95524082tamps
taps66050672taps
temps95417132temps
times75630822times
tips66436762tips
tops66248122tops
tumps95420792tumps
tups65628762tups
ump76130442ump_
ups55629052_ups
urps66920472urps
vamps125415482vamps
vims95423312vim_s
waps96642082waps
wimp115521522wimp_
wimpy155911922wimpy
wisps105214182wisps
wops96634152wops
yaps95933522yaps
yeps95924402yeps
yips95226692yips
yups96121602yups
zaps156826892zaps
zeps156019342zeps
zips155723792zips

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298721860.94031778.7
3Display Results1861860.0464043.5
 (SQL Overall)1786911861.062168258.9
 
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.