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

205 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
imp7662698(None) 
amp77541021amp
gimp96124051gimp
impi85415791impi
imps86221121imps
jimp155618471jimp
limp88432501limp
pimp106024911pimp
simp85228781simp
ump76130441ump
wimp115521531wimp
aim57858222aim_
aims67738192aims
alp56641132alp
am411875562am_
ama510853302ama
ami56646812ami
amps86230342amps
amu58237322amu
app76827602app
asp57235342asp
bap76455842bap
bima86723842bima
blimp115612942blimp
bop77549482bop
bump106228242bump
camp106336452camp
cap76758982cap
cep75736332cep
chimp145216472chimp
comp106731252comp
cop711162372cop
crimp115615802crimp
cup76738242cup
damp96228842damp
dap66652452dap
dim68146502dim_
dime76237652dime
dims75435032dims
dip67848992dip
dump95927092dump
dup67637882dup
em49445152em_
eme55837182eme
ems56435492ems
emu55929982emu
fop86743702fop
gamp98833212gamp
gap67055612gap
gimps105915202gimps
gimpy135212232gimpy
gip67645372gip
gyp98319012gyp
hap87360052hap
hemp115725622hemp
hep86644142hep
him86247672him_
hims95230982hims
hip86750442hip
hm78126732hm_
hmm106218992hmm
hop87554592hop
hump116228722hump
hup86437812hup
hyp117822462hyp
iamb86623732iamb
ice56737252ice
ich86227752ich
ick97329332ick
icy86322132icy
id38941852i_d
ids47535482ids
if57239962i_f
iff96730402iff
ifs67124252ifs
igg57116802igg
ilk78325312ilk
ill37437102ill
imam81718332imam
imid76122302imid
immy114611832immy
imped105117982imped
impel95711772impel
impis96213852impis
imply124911842imply
in28150872i_n
ink76433642ink
inn36727442inn
ins35945612ins
ion36051032ion
ire36943182ire
irk76426372irk
is27048222i_s
ism56322392ism
isms66213472isms
it28455692i_t
its35538842its
ivy96317452ivy
jimpy195210822jimpy
jump156621722jump
kemp126418772kemp
kep96437212kep
kip97042152kip
kop97440212kop
lamp86233822lamp
lap58565272lap
lima65734142lima
limb85429392limb
lime66244942lime
limn66527702limn
limo65529742limo
limpa97014462limpa
limps95522672limps
limy95727722limy
lip514755812lip
lisp68926892lisp
lop58255312lop
lump86531702lump
ma410060662_ma
map77255122map
me47748332_me
mi48249062_mi
mib76946132mib
mic77647652mic
mid67354482mid
mig65646092mig
mil55752122mil
mim76048432mim
mime85736412mime
mips85534092mips
mir57046782mir
mis58162632mis
mix126138192mix
mm67826812_mm
mo49158482_mo
mop76950822mop
mu46737482_mu
mump105425722mump
my78125652_my
nap56753202nap
nim57142962nim_
nims66226892nims
nip56945992nip
om48553002om_
oms56337512oms
op45850162_op
pap76758402pap
pep76447082pep
pima85428662pima
pimps114616982pimps
pip78051052pip
pomp106225462pomp
pop76252252pop
primp115615922primp
pump105726852pump
pup76339882pup
ramp85934002ramp
rap56261962rap
rep55847802rep
rim56052282rim_
rime65138892rime
rims65936312rims
rimy96621292rimy
rip56851312rip
romp85926572romp
rump86729082rump
samp85733592samp
sap56463232sap
sim56553152sim_
sima64730792sima
simps94719762simps
sims65737182sims
sip57656022sip
skimp135411332skimp
sop57557862sop
sump86331532sump
sup57041942sup
tamp86133012tamp
tap57663882tap
temp85323332temp
time66235022time
tip56551232tip
top510560682top
tump85927032tump
tup56037542tup
um47338832um_
umm711921262umm
umps85721942umps
up47832822_up
urp56426402urp
vamp115521542vamp
vim87437032vim_
vims95423322vims
wap86553372wap
wimps125213802wimps
wimpy155911922wimpy
wisp97124082wisp
wop87145132wop
yap85949822yap
yep86638962yep
yip87241192yip
yup86031702yup
zap145840692zap
zep147129142zep
zip146636232zip

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 Filter178691140840.560319091.1
2DLD Change Limit140842050.83016968.7
3Display Results2052050.0762697.4
 (SQL Overall)1786912051.466121890.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.