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 “gilds” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

173 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
gilds7541752(None) 
gelds75118341gelds
gids65933741gi_ds
gild65526511gild_
gills64728191gills
gilts64924261gilts
girds74816991girds
golds75421311golds
guilds8388351guilds
milds86422051milds
silds65520521silds
wilds94818201wilds
aids57846362ai_ds
ails45654712ail_s
balds85524642balds
bids75838452bi_ds
bields94110002bields
biles75542142biles
bilks115117892bilks
bills75632862bills
binds86627472binds
birds85421332birds
bolds85825282bolds
builds9378492builds
colds85726972colds
dildo71911772dildo
dildos8179302dildos
dills65530972dills
elds56324852_elds
engilds974862engilds
fids87034742fi_ds
fields104211042fields
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
finds95424822finds
folds95221692folds
gads67843382g_ads
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502gal_s
gauds75717722gauds
geds66730812g_eds
geld65828432geld_
gels56836102gel_s
gelts65924612gelts
gibes84422522gibes
gibs75529272gi_bs
gid57047272gi_d_
giddy115810202giddy
gied64631982gied_
gies55641422gi_es
gifts96214962gifts
gigas75415582gigas
gigs66631182gi_gs
gilded94413222gilded
gilder84415532gilder
gilders94212462gilders
gill56336182gil_l
gilly94321632gilly
gilt56348542gil_t
gimps105915202gimps
ginks104319562ginks
gins55543952gi_ns
gips75632922gi_ps
gird65424992gird_
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
gists66026192gists
gites65630182gites
gits55744592gi_ts
gives95324872gives
glads75620612glads
gleds75417892gleds
glias64618492glias
glide74521592glide
glides84518862glides
glims87417672glims
goads77022852goads
gods65438042g_ods
gold65430162gold_
golfs95616102golfs
goods75124482goods
gowds105814042gowds
grads75625752grads
grids75321392grids
grills74314802grills
grinds84511842grinds
guids75516152guids
guild75312752guild_
guiles73919282guiles
guilts74111232guilts
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852gul_s
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hinds96721472hinds
holds94623242holds
ids47535472_i_ds
iglus6609932iglus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kids96029642ki_ds
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kinds106221822kinds
lids56336462li_ds
lilos55821872lilos
lilts55822802lilts
melds84822382melds
mids76541792mi_ds
mild75330852mild_
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mil_s
milts75430712milts
minds85427122minds
molds85324832molds
nills54926672nills
nils46132452nil_s
oils46337972oil_s
olds55926572_olds
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
regilds996672regilds
rids56539552ri_ds
riles55343642riles
rills55032712rills
rinds64826142rinds
sild55030582sild_
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
tilde65017342tilde
tildes74513962tildes
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
velds95615582velds
vids85627542vi_ds
vills86429322vills
welds94719162welds
wields10469622wields
wild85126512wild_
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winds95425602winds
wolds95420182wolds
yids85224962yi_ds
yields10466842yields
yills83921552yills
yirds96612512yirds
zills144020782zills

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001731.61033416.1
3Display Results1731730.0463760.9
 (SQL Overall)1786911731.95291542.5
 
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.