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

512 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
simple10431517(None) 
dimple113512791dimple
pimple123512961pimple
rimple103814581rimple
sample104215011sample
semple103212751semple
simile83115631simile
simpler112910861simpler
simples113014941simples
simplex18256391simplex
simply133010521simply
wimple133611361wimple
ample94720302_ample
crimple13408692crimple
dimpled132810302dimpled
dimples122813212dimples
dimply14339742dimply
fimble133611752fimble
fipple13329062fipple
hirple11158972hirple
impale102811662_impale
impel95711772_impel
impled113812512_impled
imply124911842_imply
jimply20397482jimply
limply133810032limply
nimble103412942nimble
nipple103410372nipple
pimpled14289182pimpled
pimples133012422pimples
pimply15329212pimply
rimpled123311422rimpled
rimples113114222rimples
ripple103413912ripple
rumple103913012rumple
sampled123410782sampled
sampler113212012sampler
samples112815452samples
sempre102710092sempre
sickle124418322sickle
sidle65124032si_dle
similes92915232similes
simnel857022simnel
simp85228772simp__
simper103616292simper
simplest122310222simplest
simps94719762simp_s
single74520602single
sipe67341042si_p_e
sizzle14309612sizzle
smile74823922s_mile
staple84415822staple
stipple1146622stipple
supple10410202supple
swiple11379232swiple
swipple1444632swipple
temple102811332temple
tipple103411912tipple
wimble133211922wimble
wimpled15338822wimpled
wimples143311172wimples
aisle55223193ai_sle
amble95924643_amble
amole75724593_amole
ampler104313303_ampler
amply125012913_amply
ampule10710613_ampule
apple94517673_apple
bedimple1543133bedimple
bepimple1642503bepimple
bible95119423bi_ble
bile66147183bi__le
bindle94516263bindle
birle75023633bi_rle
bumble124216893bumble
cicale10314503cicale
circle1039703circle
citole8311503citole
compel124412893compel
compile13312443compile
complex2037243complex
comply152810383comply
couple104415963couple
crimpled15366933crimpled
crimples14308963crimples
cripple13378583cripple
crumple13368363crumple
damply14337893damply
dapple1138853dapple
dibble114013843dibble
diddle94915213diddle
dime76237643dim__e
dimly114913483dim_ly
dimplier1336673dimplier
dindle84417223dindle
dingle84317073dingle
diplex16408053di_plex
diploe9810153di_ploe
dipole91112853dipole
dispel9310323dispel
duple85315863_duple
empale102611263_empale
ensample1242983ensample
example1844283example
female11310553female
fickle153912973fickle
fiddle113613383fiddle
file75446643fi__le
fille84327403fi_lle
fimbles143510663fimbles
finale94116763finale
fipples14298653fipples
fizzle17369713fizzle
fumble133214263fumble
gamble115417183gamble
giggle94313513giggle
gimel8313353gimel_
gimels938893gimels
gimlet93716663gim_let
gimme102411343gim_me
gimmie11298183gimmie
gimp96124043gimp__
gimped123911473gimped
gimpier12247943gimpier
gimps105915203gimp_s
gimpy135212233gimp_y
girdle82110463girdle
glimpse1233763glimpse
gripple12416613gripple
guimpe1134723guimp_e
hempie132410563hempie
higgle113811743higgle
hiply134113613hi_ply
hippie132811243hippie
hirpled13157133hirpled
hirples12149643hirples
hirsle9159573hirsle
hopple132910483hopple
humble133615053humble
idle55423763_i_dle
image81411293_image
imbue939483_imbue
imide85716893_imide
imine75821063_imine
imp76626973_imp__
impala10256933_impala
impaled12288503_impaled
impaler11298393_impaler
impales113311763_impales
imped105117983_imped
impede11469623_impede
impels10389523_impels
imphee13310353_imphee
impi85415793_imp_i
impis96213853_impis
implead12315823_implead
implied1238623_implied
implies11312123_implies
implode12156103_implode
implore11176703_implore
impone103011863_impone
impose103113053_impose
imps86221123_imp_s
impulse1135113_impulse
impure1038383_impure
impute1038043_impute
ingle64120433_ingle
inkle94515833_inkle
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jiggle153811993jiggle
jimmie17376473jimmie
jimp155618463jimp__
jimper17389863jimper
jimpy195210823jimp_y
jingle143815223jingle
jumble174012653jumble
kibble143910953kibble
kindle114414233kindle
kirtle10309473kirtle
kittle104012173kittle
liable81415813liable
ligule74010833ligule
lime66244933lim__e
limp88432493limp__
limpa97014463limp_a
limpas105513083limpas
limped114817123limped
limper104117853limper
limpet103518633limpet
limpid11389753limpid
limps95522673limp_s
limpsey14365093limpsey
limpsy13516843limpsy
limuli836343limuli
lipe66839733li_p_e
lisle53916723li_sle
little63312163little
male66052293__male
maple95521143_maple
mickle143715133mickle
middle103414983middle
miggle104012113miggle
mile66352573__mile
mille75029133mi_lle
mime85736403mim__e
mingle93518783mingle
mispled12310463mispled
mizzle16279993mizzle
mole66251833__mole
mule65236973__mule
mumble123614343mumble
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimbler11358063nimbler
nimbly13388773nimbly
nippled12307643nippled
nipples11319663nipples
osmole8128513osmole
people10310183people
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pile65649693pi__le
pilule8411123pilule
pimp106024903pimp__
pimped134913483pimped
pimplier1445413pimplier
pimps114616983pimp_s
pinole83218783pinole
pintle83818263pintle
pipe86434433pi_p_e
pizzle16279493pizzle
popple92710983popple
purple102712673purple
ramble104519973ramble
rampole1139693rampole
resample1244673resample
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rime65138883rim__e
rimose8310593rimose
ripe66038923ri_p_e
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripply13348003ripply
rumble103718813rumble
rumpled123810013rumpled
rumples113313133rumples
rumply13348573rumply
sable74732163s_able
saddle83915493saddle
sale44959703s__ale
salpae84614273salpae
same65245643sam__e
samiel8313333samiel
samite83020603samite
samlet84126563sam_let
samp85733593samp__
sampan102511893sampan
samplers12299403samplers
samps96124673samp_s
scale74629143s_cale
scape96921843scap_e
scope94821483scop_e
scruple1137193scruple
scumble1337013scumble
sedile73517233sedile
selle54428313s_elle
seme65836653sem__e
sememe10129983sememe
semplice1447013semplice
senile63420213senile
settle63915663settle
shale85332833s_hale
shamble14149263shamble
shape105125113shap_e
shingle117711273shingle
shoppe133110313shoppe
sial45938833si_al_
sials54227243si_als
siamese936503siamese
sibyl1037113sibyl_
sibyls1135303sibyls
sice65545593si__ce
sickee124622223sickee
sickie123715743sickie
sickled144713433sickled
sickles133417543sickles
sickly153110483sickly
side55444483si__de
sidhe95315103si_dhe
sidled84215173si_dled
sidler74716963si_dler
sidles74721153si_dles
siege66718443si_ege
sieve84918843si_eve
sigil63515503sigil_
sigils73912363sigils
sigla64515203si_gla
sigmate10710123sigmate
signee73617233signee
sike87138783si__ke
silage72715303silage
silane62718053silane
sild55030583si__ld
silex123417413si__lex
silicle937753silicle
silk85529323si__lk
silkie103313403silkie
sill45545153si__ll
siller64026053si_ller
sills55135983si_lls
silly84527613si_lly
silo46037913si__lo
silt46558193si__lt
silvae92811093silvae
sim56553133sim___
sima64730783sim__a
simar74920813sim_ar
simars84916933simars
simas75727553sim_as
simian8811163simian
similar937853similar
simlin8311733simlin
simmer104115353simmer
simnels976103simnels
simoleon10133093simoleon
simony1137903simony
simoom1037493simoom
simoon858063simoon
simpered1338253simpered
simperer1237173simperer
simpers113014113simpers
simpleton13163033simpleton
simplexes2043983simplexes
simplices1546043simplices
simplify1843553simplify
simplism14216243simplism
simplist12249683simplist
sims65737173sim__s
simular938673simular
simulate10311133simulate
since75024173si_nce
sine46560623si__ne
singe65731133si_nge
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singly
sinopie948773sinopie
sip57656013si_p__
siped84927683si_ped
sipes76036953si_pes
sipped113720633sipped
sipper103920983sipper
sippet103519393sippet
sips65740103si_p_s
sire46150413si__re
siree55238813si_ree
sirree64017333sirree
sisal54217733sisal_
sisals63013573sisals
site47052413si__te
sixte126216583si_xte
sizable1839893sizable
size135630963si__ze
sizzled16367883sizzled
sizzler15266863sizzler
sizzles15349633sizzles
skiable1338883skiable
skiffle17225203skiffle
skimp135411313skimp__
skimped16256223skimped
skimpier1634293skimpier
skimpily1963053skimpily
skimps14488043skimp_s
skimpy17475723skimp_y
skittle1135523skittle
slime74925753slim__e
slimily1247713slimily
slimly11408903slim_ly
slimpsy1463333slimpsy
slipe75626133slip_e
slope75823563slop_e
slype105112363slyp_e
small74016263s_mall
smalt74729333s_malt
smaze165012933s_maze
smell74916233s_mell
smelt74726783s_melt
smidge10378483smidge
smiled93716433s_miled
smiler83916683s_miler
smiles84522293s_miles
smiley114012303s_miley
smite75224873s_mite
smoke115015823s_moke
smolt74824163s_molt
smote75820273s_mote
sniffle13287643sniffle
sniggle9316833sniggle
snipe75320573snip_e
socle7419573s_ocle
sole46053673s__ole
sombre10729473sombre
some66040383som__e
somite84519373somite
spae65034323s__pae
spale74929213s_pale
spicule11269933spicule
spile75230083s_pile
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
spue66025523s__pue
stable83921643stable
stale55637103s_tale
stapled103613693stapled
stapler93913623stapler
staples93617213staples
steeple937323steeple
stele55026843s_tele
steppe10319873steppe
stickle132410973stickle
stifle93611903stifle
stile54931573s_tile
stime76521793stim__e
stimuli944513stimuli
stipe76523373stip_e
stipel84412123stipel
stippled1345303stippled
stippler1235543stippler
stipples1247023stipples
stipule936723stipule
stole54928813s_tole
stope74727243stop_e
stopple1156583stopple
stumble1147553stumble
stupe75217753stup_e
style85519363s_tyle
suable83920553suable
subtle82113433subtle
suckle124015963suckle
summae103911013summae
sump86331533sump__
sumps95023433sump_s
sumpter1138873sumpter
supe65932763s_up_e
suppled1248463suppled
suppler1148433suppler
supples11511283supples
supply1346893supply
swale85221593s_wale
swindle11389183swindle
swingle113510563swingle
swipe105217083swip_e
swiples12339643swiples
swipples1534843swipples
swizzle1854103swizzle
tamale83717393tamale
templed12278553templed
temples112610893temples
templet112712003templet
thimble1435863thimble
tickle124616743tickle
tile45451443ti__le
timbale11248803timbale
timbre10328633timbre
time66235013tim__e
timely113410113timely
tingle74319053tingle
tinkle103714453tinkle
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
title54721073ti_tle
tittle63613323tittle
topple104411323topple
trample11299703trample
triple84215923triple
tumble103215643tumble
viable111613773viable
vile76139803vi__le
virile9313433virile
vittle94711753vittle
wamble134415753wamble
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimbled15298153wimbled
wimbles143010853wimbles
wimp115521523wimp__
wimped144211513wimped
wimpier14248053wimpier
wimps125213803wimp_s
wimpy155911923wimp_y
windle104617953windle
winkle133812833winkle
wintle94014603wintle
wipe94830283wi_p_e
yipe96722173yi_p_e
yippee132810743yippee
yippie13277843yippie
zizzle13247313zizzle

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.1401276364.3
2DLD Change Limit1127165126.39317631.2
3Display Results5125120.1533346.4
 (SQL Overall)1786915126.68626726.1
 
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.