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

248 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
giglot8401313(None) 
diglot83014331diglot
giglet83920271giglet
giglots9367861giglots
gigot74023071gig_ot
aiglet74224192aiglet
bigot84828322big_ot
diglots9299502diglots
giblet93418892giblet
giglets93211552giglets
gigolo836532gigolo
gigolos934692gigolos
gigots83911952gig_ots
gilt56348542gi_l_t
gimlet93716662gimlet
goglet84618582goglet
guglet84018222guglet
igloo6410492_igloo
piglet93420922piglet
pilot77435062pi_lot
sigloi737742sigloi
siglos7311472siglos
tiglon737922tiglon
wiglet105519152wiglet
aglet65534143_aglet
aglow94711973_aglow
aiglets84012913aiglets
aigret73720023aigret
airglow1143673airglow
allot54933873_allot
anglo65215373anglo_
anglos74413913anglos
argot67728653arg_ot
ballot84624093ballot
begot84625953beg_ot
bibelot1167343bibelot
bigfoot1355993bigfoot
bight118728843big_ht
bigly114814753bigl_y
bigos85020013big_os
bigots95015133big_ots
billet86029723billet
billon83713833billon
billow114111223billow
blot65842323__blot
brulot8912213brulot
chalot113020133chalot
clot66542423__clot
coplot10518273coplot
dialog837973dialog
dicot85429093di_cot
digest84019623digest
dight104027003dig_ht
digit73825273dig_it
diploe9810153diploe
diplont10311693diplont
divot95723073di_vot
drylot1037403drylot
eaglet73722583eaglet
eight94928053eig_ht
englut738453englut
ergot65422893erg_ot
faggot1139053faggot
fagot9323403fag_ot
fight124027093fig_ht
figwort1448223figwort
filet85540163fi_let
fillet95027083fillet
fillo84319783fillo_
fillos94415083fillos
filo76034283fi_lo_
filos86125383fi_los
galiot72322593galiot
gallet73630853gallet
galliot82214133galliot
gallon73715813gallon
galloot82814223galloot
gallop93311383gallop
galoot72719163galoot
galop84716223g_alop
gaslit7513503gaslit
gault65128483gaul_t
gavot9321123g_avot
gelt56448013g_el_t
gemot84024233g_emot
giant65430593gi_ant
gibbet114113383gibbet
gibbon1135323gibbon
giblets103210423giblets
gibson935123gibson
gift86735793gi__ft
gig56040753gig___
giga66720943gig__a
gigabit1145403gigabit
gigaflop1551353gigaflop
gigas75415583gig_as
gigaton946343gigaton
gigged104112293gigged
giggle94313513giggle
giggled114010073giggled
giggler101029883giggler
giggles103312933giggles
giggly12518703giggly
gighe10139733gig_he
gigs66631183gig__s
gigue71210673gig_ue
gigues8129003gigues
gild65526513gi_l_d
gilds75417523gi_lds
gill56336183gi_l_l
gilled84521633gilled
giller74519733giller
gillie74816943gillie
gillnet839733gillnet
gills64728193gi_lls
gilly94321633gi_lly
gilts64924263gi_lts
gimlets10338433gimlets
gingko12376033gingko_
gingkos13405343gingkos
ginzo1539613ginzo_
gipon84212413gi_pon
girl56226553girl__
girlie73711463girlie
girls64518393girl_s
girly94415293girl_y
giro55828633gi_ro_
giron66118993gi_ron
giros65722653gi_ros
girt56646423gi__rt
gismo848863gismo_
gismos957183gismos
gist56046763gi__st
git46266053gi___t
gizmo1756013gizmo_
gizmos1844133gizmos
gloat65427683__gloat
glob76623393__glob
glom75424383__glom
glop76724633__glop
glost65422933__glost
glout65925813__glout
glow85222523__glow
glut56331293__glut
goblet93219483goblet
goglets9379783goglets
gogo69722833gog_o_
gogos77516523gog_os
got49870443__g_ot
griot65328413g_riot
grot55942053__grot
guglets9369693guglets
guilt65125573guil_t
gullet74924833gullet
gurglet94412033gurglet
guyot9314523g_uyot
hallot95426783hallot
harlot94422803harlot
helot85332683_helot
hight125327233hig_ht
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hilt75850713hi_l_t
idiot6718863_idiot
igloos738033_igloos
iglu510814783_igl_u
iglus6609933_iglus
ingot61221063_ingot
inlet53732403_inlet
islet54527553_islet
jilt115839423ji_l_t
kilo86028663ki_lo_
kilos95021473ki_los
kilt86144413ki_l_t
kinglet123114043kinglet
light94429603lig_ht
lilo46731563li_lo_
lilos55821873li_los
lilt46349943li_l_t
lirot5430033li_rot
lot38179263___lot
maggot10311713maggot
magot8326393mag_ot
maillot9312173maillot
merlot83217603merlot
might113827083mig_ht
mignon937953mignon
mikvot1556763mikvot
millet84030743millet
milo65536103mi_lo_
milos75428013mi_los
milt65455813mi_l_t
mislit83019693mislit
night94327853nig_ht
ocelot8813383ocelot
picot95031013pi_cot
pigboat1247823pigboat
pigeon949413pigeon
piglets103311793piglets
pignut9311573pignut
pigout9314613pigout
pillow113110573pillow
pilots84018873pi_lots
pinot78737293pi_not
piolet83225643piolet
pivot106523873pi_vot
plot66141233__plot
reglet73724233reglet
reglow10339403reglow
replot83818593replot
rialto638603rialto
riblet84222443riblet
right94430503rig_ht
righto104111093righto
rigor62714053rig_or
rillet64828853rillet
ringlet82818173ringlet
riot45947213ri__ot
sight94629293sig_ht
sigla64515203sigl_a
siglum936563siglum
signet73621153signet
signor73510353signor
silo46037913si_lo_
silos56029433si_los
silt46558193si_l_t
singlet84120113singlet
slot46049833__slot
sniglet83612413sniglet
spigot9312603spig_ot
sublot82315523sublot
tight93626503tig_ht
tiglons837343tiglons
tigon63914443tig_on
tilt46252423ti_l_t
tinpot8312513tinpot
ungot61718063ung_ot
vigor92612423vig_or
violet92620923violet
wigeon1037223wigeon
wight123725573wig_ht
wiglets113411423wiglets
willet95124833willet
willow12369693willow
wilt76246293wi_l_t
winglet113115983winglet
zealot15313473zealot

Search took 6 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.1261418182.5
2DLD Change Limit1127162484.82623356.0
3Display Results2482480.0803100.0
 (SQL Overall)1786912485.03235510.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.