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

347 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
gallates9281553(None) 
gallate83417131gallate_
ablates92416902_ablates
alates64833972_a_lates
ballades114211642ballades
ballutes1037522ballutes
collates103019142collates
fellates11312752fellates
galatea839972ga_latea
galateas937152ga_lateas
galaxes1538882ga_laxes
galeate83916792galeate_
galeated104111582galeated
galettes93111162galettes
gallanted1145902gallanted
gallants93310372gallants
galletas9308132galletas
galleted1038222galleted
gallets83517402gallet_s
gallies84122712gall_ies
galluses936962galluses
gelates83219592g_elates
malates93522612ma_lates
maleates103316342maleates
palates93624942pa_lates
palliates11311032palliates
palpates122613062palpates
tallages92312002tallages
vallate103016562vallate_
valuates112811202valuates
abates85825033_a_bates
ablate82219213_ablate_
ablated102513443_ablated
acylates1339743acylates
adulates9311913adulates
aerates74627493_aerates
agates76121343_a_gates
agemates111110023agemates
agitates9310883agitates
agnates82813193_agnates
alate55340333_a_late_
alated75625153_a_lated
albatas938373_albatas
albites9313203_albites
alcades101011473_alcades
aliases7914493_aliases
alkanes113812933_alkanes
alkylates1644703_alkylates
allanites949803_allanites
allayed11138063_allayed
allayer10148213_allayer
allayers11156633_allayers
allays94313743_alla_ys
allees64521483_all_ees
alleges84212573_alleges
alleles73812033_alleles
allies63827673_all_ies
allocates11410473_allocates
allots64019173_allot_s
alludes83610333_alludes
allures72913113_allures
anlaces92313733_anlaces
anlages82414113_anlages
anlases72514903_anlases
annates72415423_annates
aplites9314933_aplites
atlantes838553_atlantes
atlases72410643_atlases
atlatls744773_atlatls
aviates10313073_aviates
balases93815433ba_lases
balatas9311833ba_latas
baldpates1445233baldpates
ballade104012563ballade_
ballads104212913balla_ds
ballasted1245453ballasted
ballaster1145973ballaster
ballasters1245093ballasters
ballasts1037933ballasts
ballets93719513ballet_s
ballgames1443573ballgames
ballies93725743ball_ies
balloted1189043balloted
balloter1078893balloter
balloters1157673balloters
ballots94116033ballot_s
ballute938543ballute_
basaltes10367683basaltes
bullaces12299433bullaces
bullate93415073bullate_
calcites12313003calcites
calculates1498703calculates
califates14310113califates
callans94518473calla_ns
callants104112143callants
callas84526753calla__s
callees94117783call_ees
callets93821703callet_s
calloses10313393calloses
calluses1039323calluses
calottes10610083calottes
canulates11312873canulates
carates95630613ca_rates
caseates10313713caseates
caudates11310263caudates
cellmates1347513cellmates
chelates132713853chelates
cholates132414763cholates
ciliates10413453ciliates
collages113514243collages
collate92919683collate_
collated113615063collated
dalles74222063dall__es
dallies84023193dall_ies
dealates92716683dealates
deflates123013943deflates
delates83526283_delates
diallages1145463diallages
dilates83220663_dilates
egalites9310503ega_lites
elates65032363__elates
eluates72014683_eluates
emulates10312573emulates
epilates10313503epilates
evaluates12247353evaluates
fabulates1447733fabulates
falcate12311623falcate_
falcated1438483falcated
fallacies1446833fallacies
fallals103310193falla_ls
fellate10313433fellate_
fellated1239563fellated
filiates11412663filiates
folates103218453_folates
foliates11412753foliates
gables94222333gabl__es
gahnites1235703gahnites
galagos938153ga_lagos
galahs105512683ga_la_hs
galas65731643ga_la__s
galaxies1637173galaxies
galeae74717453galea_e_
galeas74618513galea__s
galenites10129193galenites
galeres83514343ga_leres
gales65442483ga_l__es
galette84212703galette_
galilees936333galilees
galiots82311323galiot_s
gallamines1345493gallamines
gallant83517113galla_nt
gallantly1344253gallantly
gallantries1254143gallantries
gallantry1343363gallantry
galleass935053galleass
galleasses1163013galleasses
galled84622863gall__ed
galleins9258693galleins
galleons9258443galleons
galleries10311713galleries
gallet73630853gall__et
galleta8399653gallet_a
galley104215453gall__ey
galleys11369713gall_eys
gallflies1344223gallflies
galliards1194543galliards
galliass935423galliass
galliasses1173063galliasses
gallicas1136933gallicas
gallied94115003gall_ied
galliots9228683galliots
galliums1145963galliums
gallnuts943923gallnuts
gallonages1264563gallonages
gallons83015953gall_ons
galloons9289703galloons
galloots9268963galloots
gallopades1443773gallopades
galloped12107153galloped
galloper11137193galloper
gallopers12136323gallopers
gallops103211653gall_ops
gallous82813953gall_ous
gallows113513513gall_ows
gallowses1374953gallowses
galls64729323gall___s
gallstones1144843gallstones
gallus74313203gall__us
gallused1034193gallused
galoots82410793galoot_s
galopades1344303galopades
galores82614343ga_lores
galoshes1236913galoshes
galyacs1335273galya_cs
galyaks1534623galya_ks
gambades1435863gambades
gametes10312253ga_metes
garages9314113ga_rages
garbages1238183garbages
garlands1038323garlands
garotes8614573ga_rotes
garottes978293garottes
garrotes969383garrotes
gates65939513g___ates
gaults74112783gaul_t_s
gavages1237683ga_vages
gavottes1274183gavottes
gazettes18296863gazettes
gelate73421263g_elate_
gelated93615643g_elated
gelatis83313513g_elatis
gelatos83111523g_elatos
gellants9308283gellants
gemmates13307673gemmates
gestates93213733gestates
gillies84120963gill_ies
gillnets934733gillnets
glaces94218033g__laces
glaciates1267353glaciates
glades84820343g__lades
glares75518873g__lares
glazes165315643g__lazes
gloated93511533g_loated
gloater83711013g_loater
gloaters9288863g_loaters
gloats74515423g_loat_s
glutes74517673g__lutes
goliaths1244223goliaths
gradates10510783gradates
graduates1147683graduates
granulates1148463granulates
grates75429893g__rates
gratulates1157133gratulates
grillades1194543grillades
grillages1174943grillages
gullets84013713gullet_s
gullies84717313gull_ies
gyrates113610263g_yrates
halites103221193ha_lites
hallahs133912463halla_hs
halloes104021523hall_oes
halluces1335613halluces
hamates122917683ha_mates
haplites1339993haplites
haulages1236623haulages
haylages1536013haylages
illites72415013_illites
inflates11512193inflates
isolates8613513isolates
jaculates182810363jaculates
kalifates1646133kalifates
karates115617473ka_rates
labiates101011513labiates
lactates10311233lactates
lallands9338583lallands
lallans74113543lalla_ns
maculates132013723maculates
magnates11511613magnates
malate84624563ma_late_
maleate94117543maleate_
mallards1138323mallards
mallees93315973mall_ees
mallets93318493mallet_s
maltases1039693maltases
mandates11314093mandates
marlites103415273marlites
millages113212903millages
mullites10411643mullites
narrates8312763narrates
oblates91913243_oblates
oleates7417833_oleates
ovulates1148523ovulates
oxalates1557063oxalates
palaces114216463pa_laces
palate84226793pa_late_
paleate94120003paleate_
palettes103112833palettes
palleted1139873palleted
pallets93919303pallet_s
pallettes1148803pallettes
palliate10311893palliate_
palliated1238493palliated
palmate113215233palmate_
palmated132511003palmated
palpate113213923palpate_
palpated13249763palpated
pillages113012613pillages
placates12311753placates
plates85432243__plates
pollutes1037613pollutes
prelates10418573prelates
pulsates1048813pulsates
radiates92415293radiates
rallies73823343rall_ies
rallyes10348553rall_yes
reflates113115663reflates
relates73731433_relates
replates102919273replates
reslates83619503reslates
salivates1239293salivates
sallets73719653sallet_s
sallies73227813sall_ies
salutes73716253sa_lutes
salvages1238123salvages
satiates8314633satiates
savates10312953sa_vates
slates64934063__slates
smallages1245293smallages
solates73523853_solates
solvates11249673solvates
sublates10315003sublates
sulfates11310793sulfates
sullages939973sullages
tabulates1139143tabulates
tailgates1046533tailgates
tallage82712073tallage_
tallaged10257923tallaged
tallies73624603tall_ies
tallises82713263tallises
tallithes12286583tallithes
talliths11377433talliths
tallits73215993tallit_s
tannates81911953tannates
tillages93011263tillages
tillites8312833tillites
tollages92410193tollages
tollgates1046053tollgates
toluates8138903toluates
ullages838953_ullages
ululates848433ululates
vacates12312833va_cates
vacillates1555723vacillates
valerates12310543valerates
validates1338243validates
valuate102512733valuate_
valuated12239203valuated
valvate133710813valvate_
variates111214983variates
villages123010603villages
violates11311193violates
vulgates12237233vulgates
wallabies1445733wallabies
wallahs13409473walla_hs
wallas95719393walla__s
wallets103914833wallet_s
walleyes1435603walleyes
wallies103320743wall_ies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623476.64022012.3
3Display Results3473470.1402478.6
 (SQL Overall)1786913477.20324807.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.