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

307 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
diploe981015(None) 
diploes101111491diploes
dipole91112851dipole
deplore1039482deplore
deploy1237582deploy
dialog837972dialog
diglot83014332diglot
dildoe8198672dildoe
dimple113512792dimpl_e
diplex16408052diplex
diploic1247762diploic
diploid11310292diploid
diploma1295932diploma
diplont10311692diplont
diploses111110322diploses
dipoles101013752dipoles
dipso85111552dipso_
dipsos95310052dipsos
displode1247642displode
duple85315862dupl_e
tiptoe838282tiptoe
adipose1036653adipose
aisle55223193aisl_e
aloe45540193__aloe
ample94720303ampl_e
apple94517673appl_e
bible95119423bibl_e
bile66147183bi_l_e
bilge87618913bi_lge
billie85019173billie
billon83713833billon
billow114111223billow
biplane1139033biplane
bipod104410823bip_od
birle75023633birl_e
citole8311503citole
coplot10518273coplot
dale55643983d_al_e
daphne12237013daphne
dapple1138853dapple
dapsone1038463dapsone
dele56843083d_el_e
delve96018263d_elve
deplane10311413deplane
deplete103010413deplete
deplored1237223deplored
deplorer1136343deplorer
deplores1139533deplores
deployed1535903deployed
deployer1445633deployer
deploys1336523deploys
deplume1255063deplume
depone93616553depone
depose94215763depose
depot85727923dep_ot
depute94512303depute
dhole95215363dhol_e
dial55935063dial__
dialed84716453dialed
dialer74315433dialer
dialled9510133dialled
diallel845683diallel
dialler848813dialler
dialoged1146693dialoged
dialoger1056083dialoger
dialogs938103dialogs
dialogue1044793dialogue
dials64925343dial_s
dialyse1135463dialyse
dialyze2044433dialyze
diaphone1447103diaphone
diatom939453diatom
diazo15310033diazo_
diazole1736793diazole
dibble114013843dibble
dice75841893di__ce
dickie133913113dickie
dicot85429093di_cot
diddle94915213diddle
didie74120563di_die
dido66528193di_do_
didoes85716963di_does
didos76820813di_dos
die46759653di___e
diel59034603diel__
diene65720133di_ene
diglots9299503diglots
dike95935763di__ke
dilate73220693dilate
dildo71911773di_ldo
dildoes9229243dildoes
dildos8179303dildos
dill55239973di_l_l
dilled84122223dilled
dillies84122163dillies
dills65530973di_lls
dilly94923783di_lly
dilute72911803dilute
dime76237643di__me
dimly114913483diml_y
dimpled132810303dimpled
dimples122813213dimples
dimplier1336673dimplier
dimply14339743dimpl_y
dindle84417223dindle
dine55555333di__ne
dinge75627303di_nge
dingle84317073dingle
dingo74720793dingo_
dingoes94114833dingoes
dino56036753di_no_
dinos65428063di_nos
diobol936883diobol
diode74716113di_ode
diol57329133di__ol
diols65521013diol_s
dioptre1055763dioptre
dip67848983dip___
diphase1387273diphase
diplexer1844203diplexer
diploids1247843diploids
diploidy1544733diploidy
diplomaed1573713diplomaed
diplomas1385993diplomas
diplomat1387433diplomat
diplomate1476343diplomate
diplonts1146473diplonts
diplopia1344823diplopia
diplopic1545593diplopic
diplopod1453883diplopod
diplosis11128413diplosis
diplotene1244653diplotene
dipnet91317473dipnet
dipnoan1044653dipnoan
dipody1336363dipody
dipolar1056853dipolar
dipped123517493dipped
dipper114017793dipper
dippier123111393dippier
dippy135111543dip_py
dips75536913dip__s
dipsas9359893dipsas
dipt77339323dip__t
dire56644143di__re
dirge75117073di_rge
dirl57430023dirl__
dirled84514903dirled
dirls64720503dirl_s
disclose1148743disclose
disco85616073disco_
discoed11312483discoed
discos94915213discos
dislike122913453dislike
dislodge1145173dislodge
disme85716243di_sme
displace1348653displace
display1336663display
disploded1446543disploded
displodes1347863displodes
displume1344803displume
dispose10312763dispose
disprove14138193disprove
dispute1039083dispute
disrobe1038993disrobe
distome10313233distome
disuse74012843disuse
disyoke1546233disyoke
dite55547553di__te
ditto65315603ditto_
dittoed936733dittoed
dittos74111973dittos
diuron738573diuron
dive85634773di__ve
divide113410893divide
divine103514463divine
divot95723073di_vot
divulge1243103divulge
divulse1134913divulse
doblon938013doblon
doe47361953d___oe
dolce85816683d_olce
dole56550003d_ol_e
dollop9259363dollop
dolor67617963d_olor
doolee73018953doolee
doolie73916833doolie
dope76038893dop__e
drylot1037403drylot
dulse65415043d_ulse
duolog835803duolog
dupe76630603dup__e
duplex16386973duplex
edible969353edibl_e
edile64819493edi_l_e
employ1346493employ
employe1476363employe
epilog976463epilog
explode1745963explode
explore1646613explore
felloe93513923felloe
file75446643fi_l_e
fille84327403fi_lle
fillo84319783fillo_
fillos94415083fillos
filo76034283fi_lo_
filos86125383fi_los
filose96112503fi_lose
fipple13329063fipple
floe76129773__floe
giglot84013133giglot
gillie74816943gillie
gipon84212413gip_on
girlie73711463girlie
hillo84721653hillo_
hilloa94713033hilloa
hilloed113211293hilloed
hilloes103815963hilloes
hillos94618893hillos
hipbone1445923hipbone
hiplike1637603hiplike
hipline12311423hipline
hiply134113613hipl_y
hippie132811243hippie
hippo12369063hippo_
hippos13408433hippos
hirple11158973hirpl_e
idle55423763_idl_e
igloo6410493_igloo
implode12156103implode
implore11176703implore
isle45121703_isl_e
killie104114893killie
kilo86028663ki_lo_
kilos95021473ki_los
lilo46731563li_lo_
lilos55821873li_los
lipase8239103lipase
lipe66839733lip__e
lipide93511063lipide
liplike1337283liplike
lisle53916723lisl_e
maple95521143mapl_e
mile66352573mi_l_e
mille75029133mi_lle
milo65536103mi_lo_
milos75428013mi_los
mislie83219153mislie
nipple103410373nipple
peplos101211543peplos
pile65649693pi_l_e
pillow113110573pillow
pilose84514243pi_lose
pilot77435063pi_lot
pimple123512963pimpl_e
pinole83218783pinole
pipage1199143pipage
pipe86434433pip__e
plie65127393__plie
plod76723273__plod
plop86625743__plop
plot66141233__plot
plow95923233__plow
ploy96123603__ploy
pole65951303__pole
replot83818593replot
replow114210343replow
rifle85518333rifl_e
rile45650533ri_l_e
rille55728733ri_lle
rimple103814583rimpl_e
ripe66038923rip__e
ripple103413913ripple
sidle65124033sidl_e
sigloi737743sigloi
siglos7311473siglos
silo46037913si_lo_
siloed74615303si_loed
silos56029433si_los
simple104315173simpl_e
sipe67341043sip__e
siphon1138463siphon
sloe45534953__sloe
spile75230083spil_e
splore81611303_splore
swiple11379233swipl_e
tiglon737923tiglon
tilde65017343ti_lde
tile45451443ti_l_e
tipple103411913tipple
tiptoed1036143tiptoed
tiptoes939173tiptoes
tiptop1036103tiptop
title54721073titl_e
triple84215923tripl_e
vile76139803vi_l_e
villae95615383villae
villose1038053villose
violone1037153violone
wile75944373wi_l_e
willie94116453willie
willow12369693willow
wimple133611363wimpl_e
wipe94830283wip__e
yipe96722183yip__e
yippee132810743yippee
yippie13277843yippie
ziplock2454413ziplock

Search took 8 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.1231452772.4
2DLD Change Limit1127163077.19015676.8
3Display Results3073070.483635.6
 (SQL Overall)1786913077.79622920.9
 
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.