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
imp7662696(None) 
amp77541021amp
gimp96124041gimp
impi85415771impi
imps86221111imps
jimp155618461jimp
limp88432491limp
pimp106024901pimp
simp85228771simp
ump76130441ump
wimp115521521wimp
aim57858212aim_
aims67738182aims
alp56641132alp
am411875562am_
ama510853302ama
ami56646802ami
amps86230342amps
amu58237322amu
app76827602app
asp57235342asp
bap76455842bap
bima86723822bima
blimp115612942blimp
bop77549482bop
bump106228242bump
camp106336452camp
cap76758982cap
cep75736332cep
chimp145216472chimp
comp106731252comp
cop711162372cop
crimp115615802crimp
cup76738242cup
damp96228842damp
dap66652452dap
dim68146492dim_
dime76237642dime
dims75435022dims
dip67848982dip
dump95927092dump
dup67637882dup
em49445152em_
eme55837182eme
ems56435492ems
emu55929982emu
fop86743702fop
gamp98833212gamp
gap67055612gap
gimps105915202gimps
gimpy135212232gimpy
gip67645362gip
gyp98319012gyp
hap87360052hap
hemp115725622hemp
hep86644142hep
him86247652him_
hims95230972hims
hip86750432hip
hm78126732hm_
hmm106218992hmm
hop87554592hop
hump116228722hump
hup86437812hup
hyp117822462hyp
iamb86623722iamb
ice56737242ice
ich86227742ich
ick97329322ick
icy86322122icy
id38941832i_d
ids47535462ids
if57239942i_f
iff96730382iff
ifs67124242ifs
igg57116792igg
ilk78325302ilk
ill37437092ill
imam81718322imam
imid76122272imid
immy114611822immy
imped105117972imped
impel95711762impel
impis96213832impis
imply124911832imply
in28150862i_n
ink76433632ink
inn36727432inn
ins35945602ins
ion36051022ion
ire36943172ire
irk76426362irk
is27048212i_s
ism56322382ism
isms66213472isms
it28455682i_t
its35538832its
ivy96317442ivy
jimpy195210822jimpy
jump156621722jump
kemp126418762kemp
kep96437202kep
kip97042132kip
kop97440202kop
lamp86233822lamp
lap58565272lap
lima65734132lima
limb85429372limb
lime66244932lime
limn66527692limn
limo65529732limo
limpa97014462limpa
limps95522672limps
limy95727712limy
lip514755802lip
lisp68926872lisp
lop58255312lop
lump86531702lump
ma410060652_ma
map77255112map
me47748332_me
mi48249042_mi
mib76946102mib
mic77647632mic
mid67354452mid
mig65646072mig
mil55752102mil
mim76048412mim
mime85736392mime
mips85534072mips
mir57046762mir
mis58162612mis
mix126138172mix
mm67826812_mm
mo49158482_mo
mop76950822mop
mu46737482_mu
mump105425722mump
my78125652_my
nap56753202nap
nim57142952nim_
nims66226882nims
nip56945982nip
om48553002om_
oms56337512oms
op45850162_op
pap76758402pap
pep76447082pep
pima85428652pima
pimps114616982pimps
pip78051042pip
pomp106225462pomp
pop76252252pop
primp115615922primp
pump105726852pump
pup76339882pup
ramp85934002ramp
rap56261962rap
rep55847802rep
rim56052272rim_
rime65138882rime
rims65936302rims
rimy96621282rimy
rip56851302rip
romp85926572romp
rump86729082rump
samp85733592samp
sap56463232sap
sim56553132sim_
sima64730782sima
simps94719762simps
sims65737172sims
sip57656012sip
skimp135411312skimp
sop57557862sop
sump86331532sump
sup57041942sup
tamp86133002tamp
tap57663872tap
temp85323332temp
time66235012time
tip56551222tip
top510560682top
tump85927032tump
tup56037542tup
um47338832um_
umm711921262umm
umps85721942umps
up47832822_up
urp56426392urp
vamp115521542vamp
vim87437022vim_
vims95423312vims
wap86553372wap
wimps125213802wimps
wimpy155911922wimpy
wisp97124072wisp
wop87145132wop
yap85949822yap
yep86638962yep
yip87241172yip
yup86031702yup
zap145840692zap
zep147129142zep
zip146636222zip

Search took 1 second 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.0602978183.3
2DLD Change Limit140842050.44032009.1
3Display Results2052050.0306833.3
 (SQL Overall)1786912050.530337152.8
 
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.