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 “jimply” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

261 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
jimply2039748(None) 
dimply14339741dimply
imply124911841_imply
jimpy195210821jimp_y
limply133810031limply
pimply15329211pimply
simply133010521simply
amply125012912_amply
comply152810382comply
damply14337892damply
dimly114913482dim_ly
dimple113512792dimple
gimpy135212232gimp_y
hiply134113612hi_ply
jiggly18378712jiggly
jiminy1836272jiminy
jimmy19538502jim_my
jimp155618462jimp__
jimper17389862jimper
jingly174111932jingly
jumpily2174982jumpily
jumpy195712812jump_y
limpsy13516842limpsy
nimbly13388772nimbly
pimple123512962pimple
rimple103814582rimple
ripply13348002ripply
rumply13348572rumply
simple104315172simple
timely113410112timely
wimple133611362wimple
wimpy155911922wimp_y
airily93014823airily
airplay1245483airplay
ample94720303_ample
apply125111393_apply
bialy105119323bi_aly
bigly114814753bi_gly
billy105525363bi_lly
biopsy1334533biopsy
bumpily1665653bumpily
bumpy144715053bump_y
campily1638273campily
campy145116183camp_y
chimbly1974593chimbly
cicely1338833cicely
comely134213733comely
crimple13408693crimple
crimpy15489393crimp_y
crisply14426523crisply
crumply16336093crumply
deeply1257013deeply
diddly12389573diddly
dilly94923783di_lly
dimity12310473dimity
dimpled132810303dimpled
dimples122813213dimples
dinkly144311083dinkly
dippy135111543di_ppy
direly10311563direly
display1336663display
dumbly14399603dumbly
dumpily1566233dumpily
dumpy135414753dump_y
employ1346493_employ
empty1247763_empty
family143311703family
fickly18318533fickly
fiddly14328483fiddly
filly114424903fi_lly
filmily1535733filmily
fimble133611753fimble
finely123011563finely
fipple13329063fipple
firmly1436663firmly
fitly115114973fi_tly
gamely124711913gamely
gamily123712183gamily
giggly12518703giggly
gilly94321633gi_lly
gimel8313353gimel_
gimels938893gimels
gimp96124043gimp__
gimped123911473gimped
gimps105915203gimp_s
gipsy11579543gi_psy
girly94415293gi_rly
grimily1336523grimily
grimly12459933grim_ly
haply135915063_haply
hempy154912763hemp_y
highly1636823highly
hilly114422163hi_lly
hippy155112793hi_ppy
hirple11158973hirple
homely145313173homely
homily144712333homily
humbly164010523humbly
humpy155115673hump_y
icily101211693_icily
idly85617323_i_dly
illy76925333_i_lly
immy114611833_im_my
imp76626973_imp__
impala10256933_impala
impale102811663_impale
imped105117983_imped
impel95711773_impel
impels10389523_impels
impi85415793_imp_i
impis96213853_impis
impled113812513_impled
imps86221123_imp_s
inly75622213_i_nly
jammy194810193jam_my
jangly174310603jangly
jelly154218253j_elly
jemmy19498553jem_my
jiffy21458313ji_ffy
jiggle153811993jiggle
jiggy17549143ji_ggy
jill116430263ji__ll
jills125122823ji_lls
jilt115839423ji__lt
jimmie17376473jimmie
jimminy2133373jimminy
jimpest18297553jimpest
jingle143815223jingle
jitney16304623jitney
jivey185111873ji_vey
jivy176213113ji__vy
jointly1735483jointly
jokily20306533jokily
jolly154517513j_olly
jowly186410903j_owly
juicily1935493juicily
jumble174012653jumble
jump156621723jump__
jumped183511553jumped
jumper173612373jumper
jumps165116493jump_s
jungly17407693jungly
justly16307253justly
kindly14358843kindly
kingly143511303kingly
lamely114013223lamely
liefly1266363liefly
likely13328133likely
lily76730183li__ly
limby125714073lim_by
limey104721043lim_ey
limp88432493limp__
limpa97014463limp_a
limpas105513083limpas
limped114817123limped
limper104117853limper
limpet103518633limpet
limpid11389753limpid
limpidly1643153limpidly
limps95522673limp_s
limpsey14365093limpsey
limuli836343limuli
limy95727713lim__y
lippy124511903li_ppy
lively123310813lively
lumpily1476563lumpily
lumpy126615913lump_y
mildly12318243mildly
misplay1436383misplay
mizzly19256103mizzly
moly96031913__moly
mumbly15319463mumbly
namely113711323namely
nicely1139493nicely
niggly11418913niggly
nimble103412943nimble
nippily1444713nippily
nipple103410373nipple
nippy124911113ni_ppy
numbly134410663numbly
oilily93111723oilily
oily77932253oi__ly
piddly13319143piddly
pily96132733pi__ly
pimp106024903pimp__
pimped134913483pimped
pimpled14289193pimpled
pimples133012423pimples
pimps114616983pimp_s
pinkly155012243pinkly
pipy115421513pi_p_y
plumply1634223plumply
ply86323553___ply
primely1457723primely
primly13439623prim_ly
purply13369053purply
reply104015853_reply
richly1438003richly
rifely123710033rifely
rimpled123311423rimpled
rimples113114223rimples
rimy96621283rim__y
ripely112511153ripely
ripple103413913ripple
rumbly134412163rumbly
rumple103913013rumple
sample104215013sample
semple103212753semple
sickly153110483sickly
silly84527623si_lly
simile83115633simile
simony1137903simony
simp85228773simp__
simper103616293simper
simpler112910863simpler
simples113014943simples
simplex18256393simplex
simplify1843553simplify
simps94719763simp_s
singly104015853singly
skimpily1963053skimpily
skimpy17475723skimp_y
slimily1247713slimily
slimly11408903slim_ly
slimpsy1463333slimpsy
supply1346893supply
tamely113711953tamely
temple102811333temple
tiddly11308783tiddly
tidily102811393tidily
timidly1334593timidly
tingly103815973tingly
tinily94014433tinily
tinkly134811153tinkly
tipple103411913tipple
tippy125411793ti_ppy
tipsy106010503ti_psy
trimly114410893trim_ly
triply114211023triply
vampy15539403vamp_y
viably14199833viably
vilely1239443vilely
wambly16388663wambly
widely133311033widely
wifely15429423wifely
wiggly14559683wiggly
wildly13328123wildly
wilily123310763wilily
willy115321913wi_lly
wily106428813wi__ly
wimble133211923wimble
wimp115521523wimp__
wimped144211513wimped
wimpled15338823wimpled
wimples143311173wimples
wimps125213803wimp_s
wirily123310783wirily
wisely122711713wisely
wispily1535653wispily
wispy137210973wisp_y
zippy21518743zi_ppy

Search took 7 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162615.62320045.5
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.10929250.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.