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

251 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
diglots929950(None) 
diglot83014331diglot_
giglots9367861giglots
aiglets84012912aiglets
bigots95015132big_ots
dialogs938102dialogs
dicots94915792di_cots
digests93610612digests
dights114016962dig_hts
digits84114532dig_its
diploes101111492diploes
diplonts1146472diplonts
divots104712202di_vots
drylots1143742drylots
giglets93211552giglets
giglot84013132giglot_
gigots83911952gig_ots
igloos738032_igloos
piglets103311792piglets
pilots84018872pi_lots
siglos7311472siglo_s
tiglons837342tiglons
wiglets113411422wiglets
aglets73915683_aglets
aiglet74224193aiglet_
aigrets82810533aigrets
airglows1243463airglows
allots64019173_allots
anglos74413913anglo_s
argots74116033arg_ots
ballots94116033ballots
bibelots1295133bibelots
bigfoots1443633bigfoots
bights124417963big_hts
bigos85020013big_o_s
bigot84828323big_ot_
billets94516153billets
billons93013363billons
billows123611293billows
blots75626173__blots
brulots946223brulots
bugloss1035893bugloss
clots75627643__clots
coplots11511593coplots
daglock1544263daglock
daglocks1643993daglocks
dagoes85714603dag_oes
dagos76419443dag_o_s
dayglows1641953dayglows
degusts936063degusts
delfts10439673d_elfts
delts65731793d_el_ts
deploys1336523deploys
depots94716343d_epots
despots10319683despots
dialects11126003dialects
dialers83614303dialers
dialist8517763dialist
dialists9411413dialists
dialog837973dialo_g
dials64925343dial__s
diatoms1039073diatoms
dicasts1078703dicasts
dicot85429093di_cot_
didacts1186063didacts
didoes85716963di_does
didos76820813di_do_s
diets66026643di__ets
digamous1296063digamous
digest84019623digest_
diggers104413393diggers
dight104027003dig_ht_
digit73825273dig_it_
diglossia1152283diglossia
diglossic1352773diglossic
dignity1236453dignity
digress938323digress
digs66036053dig___s
diktats1235623diktats
dilate73220693di_late
dilates83220663di_lates
dildoes9229243dildoes
dildos8179303di_ldos
dillies84122163dillies
dills65530973di_l_ls
dilute72911803di_lute
dilutes82911973di_lutes
dimouts1037893dimouts
dimwits1344513dimwits
dingbats1245013dingbats
dingles93818323dingl_es
dingoes94114833dingoes
dinos65428063di_no_s
dints67431313di__nts
diobols1036543diobols
diols65521013di__ols
diploe9810153diplo_e
diploic1247763diploic
diploid11310293diploid
diploids1247843diploids
diploma1295933diploma
diplomas1385993diplomas
diplomats1485373diplomats
diplont10311693diplont
diploses111110323diploses
diplosis11128413diplosis
dipnets10109033dipnets
dipoles101013753dipoles
dipsos95310053dipso_s
diquats1745983diquats
directs102710263directs
dirls64720503dirl__s
dirts66824463di__rts
discos94915213disco_s
disgusts1045653disgusts
disports111111113disports
disroots948623disroots
distorts91112353distorts
dits56450523di___ts
dittos74111973ditto_s
diurons838823diurons
diverts114412033diverts
divests114510933divests
divot95723073di_vot_
dixits144210313di_xits
doblons1037043doblons
dogdoms1295423dogdoms
doglegs1034783doglegs
dogtrots1044693dogtrots
dollops10287963dollops
dolors75115313d_olors
dolts65626313d_ol_ts
dots55647663d___ots
driblets11266093driblets
drylot1037403drylot_
dugouts935043dugouts
duologs935363duologs
eaglets84111663eaglets
eights103618983eig_hts
engluts834533engluts
ergots74512373erg_ots
faggots1234863faggots
fagots1039963fag_ots
fights133816553fig_hts
figworts1544683figworts
filets94718953fi_lets
fillets103414753fillets
fillos94415083fillo_s
filos86125383fi_lo_s
giblets103210423giblets
giglet83920273giglet_
gigolos934693gigolos
gigot74023073gig_ot_
gilts64924263gi_l_ts
gimlets10338433gimlets
gloats74515423__gloats
globs85616403__globs
gloms85219783__gloms
glops85619553__glops
gloss64319623__gloss
glost65422933__glost
glosts74513813__glosts
glouts74414713__glouts
glows95518033__glows
gluts66120133__gluts
goglets9379783goglets
grots65025853__grots
guglets9369693guglets
harlots103413293harlots
helots95217703_helots
hights133716893hig_hts
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilts86924413hi_l_ts
idiots768643_idiots
igloo6410493_iglo_o
iglus6609933_igl_us
ingots7912063_ingots
inlets63915573_inlets
islets64513083_islets
jilts124717413ji_l_ts
kilos95021473ki_lo_s
kilts95122183ki_l_ts
kinglets13318583kinglets
lights104519913lig_hts
lilos55821873li_lo_s
lilts55822803li_l_ts
lots47652093___lots
maggots1136563maggots
magots9312363mag_ots
maillots1037473maillots
merlots92710123merlots
mights123516253mig_hts
mignons1037863mignons
millets94216843millets
milos75428013mi_lo_s
milts75430713mi_l_ts
nights104117723nig_hts
ocelots977233ocelots
picots104616443pi_cots
pigboats1344523pigboats
pigeons1039183pigeons
piglet93420923piglet_
pignuts1035613pignuts
pigouts1037593pigouts
pillows122610123pillows
pilot77435063pi_lot_
pilous84717753pi_lous
pinots85920273pi_nots
piolets93513193piolets
pivots115111903pi_vots
plots75025673__plots
reglets83512983reglets
regloss8218023regloss
reglows11288843reglows
replots93412633replots
rialtos736613rialtos
riblets93412553riblets
rights104019333rig_hts
rigors72813713rig_ors
rillets74216153rillets
ringlets92910233ringlets
riots54922013ri__ots
sights103818013sig_hts
sigloi737743siglo_i
signets83311503signets
signors83410913signors
silos56029433si_lo_s
silts55330823si_l_ts
singlets93611473singlets
slots54830533__slots
sniglets9276813sniglets
spigots1037793spig_ots
sublots92410913sublots
tights104015853tig_hts
tiglon737923tiglo_n
tigons74112263tig_ons
tilts55325613ti_l_ts
vigors102911483vig_ors
villous102810023villous
violets102210003violets
wigeons1136983wigeons
wights133315783wig_hts
wigless11359673wigless
wiglet105519153wiglet_
willets104414323willets
willows13299753willows
wilts85023503wi_l_ts
winglets12299593winglets
zealots1636763zealots

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 Filter1786911340270.453394461.4
2DLD Change Limit1340272516.48320673.6
3Display Results2512510.1102281.8
 (SQL Overall)1786912517.04625360.6
 
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.