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

159 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
gables9422233(None) 
ables75935541_ables
cables104527551cables
fables114921671fables
gabbles124415411gabbles
gabies93820731gabies
gable85325521gable_
gabled105518451gabled
gales65442481ga_les
gambles124016201gambles
garbles104016921garbles
sables85026691sables
tables84524891tables
abbes96723522_abbes
abeles84719392_abeles
able66340532_able_
abled86926832_abled
abler75624312_abler
ablest84721832_ablest
abyes105518532_abyes
ales47067102_a_les
ambles105121862ambles
arables91814972arables
arles56735742_arles
axles125219472_axles
babbles104416322babbles
babels105216722babels
babes95834112bab_es
babies106123652babies
bales76250082ba_les
baubles113611862baubles
bibles104617642bibles
cable95329912cable_
cabled114819872cabled
cabler104519172cabler
cablers114416712cablers
cablet104429462cablet
cablets114216342cablets
carles85435082carles
caules85927252caules
cobles104622882cobles
dabbles124514772dabbles
dales66439742da_les
dalles74222062dalles
eagles73819162eagles
enables92813122enables
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fablers124812612fablers
farles96025782farles
gabbed125216892gabbed
gabber114916602gabber
gabbers124612832gabbers
gabble113815722gabble_
gabbled134112452gabbled
gabbler124013302gabbler
gabblers134110082gabblers
gabelles11278932gabelles
gabfest1336452gabfest
gabs76740422gab__s
gaes56348032ga__es
gaffes134811102gaffes
gages74529972ga_ges
gaggles103512592gaggles
galas65731642ga_las
gale56347322ga_le_
galea64722932ga_lea
galeas74618512ga_leas
galled84622862galled
gallet73630852gallet
gallets83517402gallets
galley104215452galley
galleys11369712galleys
gallies84122712gallies
galls64729322ga_lls
gallus74313202gallus
gals57946502ga_l_s
gambes116318312gambes
gamble115417182gamble_
gambled134112162gambled
gambler123612682gambler
gamblers13369732gamblers
games86238552ga_mes
gaoled84814502gaoled
gaoler73913572gaoler
gaolers83511562gaolers
gaols66717572gaol_s
gapes86030822ga_pes
gapless10349992gapless
garble94118452garble_
garbled114512802garbled
garbler104012562garbler
garblers113810282garblers
garbless11388252garbless
gargles94214892gargles
gases65633992ga_ses
gashes105725152gashes
gasless8319012gasless
gasses75724782gasses
gates65939512ga_tes
gauges85915992gauges
gaults74112782gaults
gauzes164710632gauzes
gavels105911092gavels
gazes155425912ga_zes
gibes84422522gib_es
giblet93418892giblet
giblets103210422giblets
gobbles123512582gobbles
gobies95418062gobies
goblet93219482goblet
goblets103210182goblets
goboes95914442goboes
grabbles13339892grabbles
guiles73919282guiles
gules64831042g_ules
gybes115012722gyb_es
hales85449842ha_les
haoles94919802haoles
kales95730982ka_les
kayles134712002kayles
labels84515682labels
ladles74619542ladles
mabes96331532mab_es
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
marbles114516652marbles
nabes75427092nab_es
nobles83319722nobles
padles95221122padles
pales75753802pa_les
parles86334402parles
rabbles113517972rabbles
rabies85226022rabies
rales54947492ra_les
rambles113118312rambles
robles85321692robles
rubles83921702rubles
sabes76437462sab_es
sable74732162sable_
sabres85520862sabres
sales56055592sa_les
stables93219072stables
tabes76033922tab_es
tablas83716162tablas
table75429602table_
tabled94020042tabled
tablet84227642tablet
tablets94714382tablets
tales55451372ta_les
umbles103817492umbles
vales85434262va_les
wabbles144013992wabbles
wales86142832wa_les
wambles143714022wambles
warbles123215562warbles

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511592.72030349.6
3Display Results1591590.0463456.5
 (SQL Overall)1786911593.12657162.8
 
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.