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

218 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
giglots936786(None) 
diglots9299501diglots
giglets93211551giglets
giglot84013131giglot_
gigots83911951gig_ots
aiglets84012912aiglets
bigots95015132big_ots
diglot83014332diglot_
giblets103210422giblets
giglet83920272giglet_
gigolos934692gigolos
gigot74023072gig_ot_
gilts64924262gi_l_ts
gimlets10338432gimlets
goglets9379782goglets
guglets9369692guglets
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
dialogs938103dialogs
dicots94915793di_cots
digests93610613digests
dights114016963dig_hts
digits84114533dig_its
diploes101111493diploes
diplonts1146473diplonts
divots104712203di_vots
drylots1143743drylots
eaglets84111663eaglets
eights103618983eig_hts
engluts834533engluts
ergots74512373erg_ots
faggots1234863faggots
fagots1039963fag_ots
fights133816553fig_hts
figworts1544683figworts
filets94718953fi_lets
fillets103414753fillets
fillos94415083fillo_s
filos86125383fi_lo_s
galiots82311323galiots
gallets83517403gallets
galliots9228683galliots
gallons83015953gallons
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoots82410793galoots
galops94712623g_alops
gaults74112783gaul_ts
gavots1038113g_avots
gelts65924613g_el_ts
gemots93712153g_emots
giants74713503gi_ants
gibbets12417723gibbets
gibbons1234983gibbons
gibbous1265333gibbous
giblet93418893giblet_
gibsons1045043gibsons
gifts96214963gi__fts
gigabits1243533gigabits
gigaflops1651343gigaflops
gigas75415583gig__as
gigaton946343gigaton
gigatons1046053gigatons
gigglers11297403gigglers
giggles103312933giggles
gigolo836533gig_olo
gigs66631183gig___s
gigues8129003gig_ues
gilds75417523gi_l_ds
gillers84216903gillers
gillies84120963gillies
gillnets934733gillnets
gills64728193gi_l_ls
gilt56348543gi_l_t_
gimlet93716663gimlet_
gingkoes14404733gingkoes
gingkos13405343gingko_s
ginzoes1735433ginzoes
gipons9389603gi_pons
girlies83013703girlies
girls64518393girl__s
girons75014373gi_rons
giros65722653gi_ro_s
girts65423623gi__rts
gismos957183gismo_s
gists66026193gi__sts
gits55744593gi___ts
gizmos1844133gizmo_s
gloats74515423__gloats
globs85616403__globs
gloms85219783__gloms
glops85619553__glops
gloss64319623__gloss
glost65422933__glost
glosts74513813__glosts
glouts74414713__glouts
glows95518033__glows
gluts66120133__gluts
goblets103210183goblets
goglet84618583goglet_
gogos77516523gog_o_s
griots74713643g_riots
grots65025853__grots
guglet84018223guglet_
guilts74111233guil_ts
gullets84013713gullets
gurglets10355543gurglets
guyots1036003g_uyots
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 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272185.59623950.5
3Display Results2182180.0762868.4
 (SQL Overall)1786912186.07529414.2
 
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.