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

228 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
galleted103822(None) 
palleted1139871palleted
alleged9389322_alleged
balloted1189042balloted
billeted1137642billeted
bulleted1138392bulleted
colleted113011662colleted
filleted1236602filleted
galeated104111582galeated
gallanted1145902gallanted
gallate83417132gallate_
gallates92815532gallates
galled84622862gall__ed
galleried1146932galleried
gallet73630852gallet__
galleta8399652gallet_a
galletas9308132galletas
gallets83517402gallet_s
gallied94115002gall_ied
galloped12107152galloped
gallused1034192gallused
gantleted1144392gantleted
garreted1057522garreted
gimleted1243972gimleted
gleeted9379322g_leeted
pelleted1138202pelleted
tableted1137532tableted
valeted1139012va_leted
valleyed1534012valleyed
walleyed1534152walleyed
ablated102513443_ablated
abluted10188363_abluted
alated75625153_a_lated
alerted82512223_alerted
aliened81011743_aliened
allayed11138063_allayed
allee54932123_alle_e_
allees64521483_alle_es
allege74314653_allege_
alleger8319633_alleger
alleges84212573_alleges
allele64514563_allele_
alleles73812033_alleles
allied74217153_all_ied
allotted986873_allotted
allowed111610083_allowed
alloyed11158033_alloyed
allseed835953_allseed
alluded9327093_alluded
allured8299173_allured
altered83215743_altered
ballasted1245453ballasted
balled94926893ball__ed
ballet84733973ballet__
balletic1248073balletic
ballets93719513ballet_s
balloter1078893balloter
ballute938543ballute_
ballutes1037523ballutes
basseted1136753basseted
billeter1037563billeter
cacheted16148233cacheted
called94126733call__ed
callee84327293calle_e_
callees94117783calle_es
callet84536763callet__
callets93821703callet_s
callused1135853callused
carpeted1338953carpeted
casketed1534953casketed
chapleted1743973chapleted
collated113615063collated
collected1447973collected
dallied93713613dall_ied
deleted93314913_deleted
depleted12258723depleted
faceted13509563fa_ceted
falcated1438483falcated
fallowed15127753fallowed
faltered122810993faltered
faulted11227723faul_ted
fellated1239563fellated
fileted1159093_fileted
fleeted113310233_fleeted
fullered1236383fullered
gabelled12317583gabelled
gabled105518453gabl__ed
gaited84416923ga__ited
galatea839973ga_latea
galeae74717453ga_leae_
galeate83916793galeate_
galere73716683ga_lere_
galeres83514343ga_leres
galette84212703ga_lette
galettes93111163galettes
galilee8312213galile_e_
galilees936333galile_es
galleass935053galleass
gallein8299043galle_in
galleins9258693galleins
galleon8278713galle_on
galleons9258443galleons
galleria946483galleria
galleries10311713galleries
gallery11468743galle_ry
galleting1137633galleting
galley104215453gall__ey
galleys11369713galle_ys
galliard10125753galliard
gallies84122713gall_ies
gallooned1144473gallooned
galloper11137193galloper
galluses936963galluses
galoped11138083ga_loped
galoshed1334493galoshed
gamete9313593ga_mete_
gametes10312253ga_metes
gandered112211173gandered
gaoled84814503gaol__ed
gardened1137003gardened
garmented1345883garmented
garnered10247113garnered
garoted9710133ga_roted
garotted1066193garotted
garroted1056783garroted
gartered10319593gartered
gasted84821583ga__sted
gated75329773ga___ted
gathered13149383gathered
gauleiter1042933gauleiter
gauntleted1241363gauntleted
gaveled12399133ga_veled
gavelled13387363gavelled
gavotted1363343gavotted
gazetted19234853gazetted
gelated93615643g_elated
gelled84718893gell__ed
gibbeted1492783gibbeted
gilled84521633gill__ed
gillied95512313gill_ied
gillnetted1251793gillnetted
glaceed1136203glace_ed
gleed75320573g__le_ed
gleeked13346333g_leeked
gleyed11478153g__leyed
glinted9399373g_linted
gloated93511533g_loated
glouted9429713g_louted
glutted937243g_lutted
gorgeted1135353gorgeted
greeted93111383g_reeted
gulled84521373gull__ed
gullet74924833gullet__
gullets84013713gullet_s
gullied93812063gull_ied
gusseted1043553gusseted
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179493hallowed
halted105019603ha_l_ted
haltered123112563haltered
helmeted1435833helmeted
hollered1237603hollered
isleted837523_isleted
jacketed22146533jacketed
lalled74218753lall__ed
lanceted1137073lanceted
lappeted13255833lappeted
leafleted1342893leafleted
malled94626113mall__ed
mallee84525593malle_e_
mallees93315973malle_es
mallet84433053mallet__
mallets93318493mallet_s
malted94819863ma_l_ted
marketed1537323marketed
milleped1335173milleped
packeted17148283packeted
palled94625163pall__ed
pallet84232653pallet__
palletised1344513palletised
palletized2245453palletized
pallets93919303pallet_s
pallette1039513pallette
pallettes1148803pallettes
palliated1238493palliated
palmated132511003palmated
palpated13249763palpated
paltered113012493paltered
pargeted1238683pargeted
parleyed1436243parleyed
pollened1157783pollened
polluted1135433polluted
rabbeted1334443rabbeted
racheted14149503racheted
racketed15169123racketed
rallied83514083rall_ied
sacheted14127833sacheted
sallet63734543sallet__
sallets73719653sallet_s
sallied83316953sall_ied
sallowed12149033sallowed
salted74121203sa_l_ted
saluted84511713sa_luted
sleeted83113223_sleeted
tabletted1244833tabletted
talented938423talented
tallaged10257923tallaged
tallied83314753tall_ied
tallowed12157713tallowed
targeted1037483targeted
telneted935073telneted
tillered937443tillered
toileted936993toileted
unalleged1144453unalleged
vallate103016563vallate_
valuated12239203valuated
vaulted11307193vaul_ted
velveted1533833velveted
volleyed1543533volleyed
walled104021293wall__ed
wallet93327093wallet__
wallets103914833wallet_s
walleye1336243walleye_
walleyes1435603walleyes
walloped14146833walloped
wallowed15148163wallowed

Search took 9 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.466383457.1
2DLD Change Limit1461622287.98618302.3
3Display Results2282280.0763000.0
 (SQL Overall)1786912288.52820953.4
 
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.