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

174 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
tables8452489(None) 
ables75935541_ables
cables104527551cables
fables114921671fables
gables94222331gables
sables85026691sables
stables93219071stables
tabes76033921tab_es
tablas83716161tablas
table75429601table_
tabled94020041tabled
tablet84227641tablet
tablets94714381tablets
tales55451371ta_les
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
eatables10169792eatables
enables92813122enables
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fablers124812612fablers
farles96025782farles
gabbles124415412gabbles
gabies93820732gabies
gable85325522gable_
gabled105518452gabled
gales65442482ga_les
gambles124016202gambles
garbles104016922garbles
hales85449842ha_les
haoles94919802haoles
kales95730982ka_les
kayles134712002kayles
labels84515682labels
ladles74619542ladles
mabes96331532mab_es
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
marbles114516652marbles
nabes75427092nab_es
nobles83319722nobles
notables10178242notables
padles95221122padles
pales75753802pa_les
parles86334402parles
potables12179702potables
rabbles113517972rabbles
rabies85226022rabies
rales54947492ra_les
rambles113118312rambles
ratables10159722ratables
retables101712672retables
robles85321692robles
rubles83921702rubles
sabes76437462sab_es
sable74732162sable_
sabres85520862sabres
sales56055592sa_les
stabiles10311402stabiles
stable83921642stable_
stabled103514952stabled
stabler94014932stabler
stablers103611152stablers
stablest103312942stablest
stales65538292sta_les
staples93617212staples
tabbed114215362tabbed
tabbies112913502tabbies
tabbis102910862tabbis
taber73825822tab_er
tabers84621572tabers
tabla73318362tabl_a
tableau966282tableau
tableaus1054852tableaus
taboos83815432taboos
tabors84517112tabors
tabs66842982tab__s
tabued94310402tabued
tabulis938832tabulis
tabuns8489222tabuns
tabus74820922tab_us
taces76237802ta_ces
taches114224172taches
tackles133816522tackles
taels56822072tael_s
tailed74424662tailed
tailer63823732tailer
tailers73720182tailers
tailles72516472tailles
tails55634192tail_s
tajes124920692ta_jes
takes94437792ta_kes
talas55935892ta_las
talcs74817182ta_lcs
tale46154162ta_le_
taler56034862ta_ler
talers64628142ta_lers
talks94322692ta_lks
taller63721962taller
tallest7317092tallest
tallies73624602tallies
tallis63319962tallis
talls55133432ta_lls
talus55423262ta_lus
tamales93216152tamales
tames75242012ta_mes
tangles83920042tangles
tapes75838602ta_pes
tares57456562ta_res
targes74524592targes
tarres64723042tarres
tasses64826762tasses
tastes64126422tastes
tates55444982ta_tes
tattles73616282tattles
taupes8212672taupes
tawses94913192tawses
taxables1734382taxables
taxes124730822ta_xes
taxies135817332taxies
taxless1436912taxless
teazles16308922teazles
teles54536002t_eles
tholes94919782tholes
tiles55542102t_iles
titles63719922titles
tobies84521022tobies
toiles63923512toiles
toles55147132t_oles
trebles9311442trebles
tubes74826452tub_es
tubules9310232tubules
tules54532792t_ules
tulles63218892tulles
tumbles113816022tumbles
umbles103817492umbles
vales85434262va_les
wabbles144013992wabbles
wales86142832wa_les
wambles143714022wambles
warbles123215562warbles

Search took 3 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.373479064.3
2DLD Change Limit825511742.29635954.3
3Display Results1741740.0503480.0
 (SQL Overall)1786911742.71965719.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.