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

126 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
taxables173438(None) 
taxable1639071taxable_
arables91814972_arables
eatables10169792eatables
parables121613562parables
payables15166482payables
ratables10159722ratables
tables84524892t__ables
takable13310192takable_
tamable11312852tamable_
tamales93216152tama_les
taxably1936042taxabl_y
waxable1937672waxable_
ables75935543___ables
ambles105121863_a_mbles
anableps1243123_anableps
arable81821003_arable_
axles125219473_ax__les
babbles104416323ba_bbles
baubles113611863ba_ubles
cables104527553__cables
capable13313363capable_
capabler1435353capabler
capablest1544883capablest
cascables15165773cascables
dabbles124514773da_bbles
datable101714233datable_
disables11410903disables
durables11237013durables
eatable91717603eatable_
enables92813123_enables
fables114921673__fables
fadable13310463fadable_
fixable19218193fixable_
gabbles124415413ga_bbles
gables94222333__gables
gambles124016203ga_mbles
garbles104016923ga_rbles
gazaboes2043863gazaboes
hatable121713963hatable_
jacales16310323jaca_les
lavaboes1344433lavaboes
makable15510203makable_
manacles1239523manacles
marbles114516653ma_rbles
mixable18259173mixable_
movables15175573movables
namable11312343namable_
notables10178243notables
parable111819773parable_
payable141711323payable_
potables12179703potables
rabbles113517973ra_bbles
rambles113118313ra_mbles
ratable91717553ratable_
retables101712673retables
sables85026693__sables
salable91415463salable_
savable121711863savable_
sayable121411613sayable_
sparables13167163sparables
stables93219073_stables
statable10310703statable_
storables1146283storables
tabbies112913503ta_bbies
tabes76033923t__ab_es
tablas83716163t__ablas
table75429603t__able_
tabled94020043t__abled
tablet84227643t__ablet
tablets94714383t__ablets
tackles133816523ta_ckles
tadpoles1135953tadpoles
tailles72516473ta_illes
takahes1436173taka_hes
takeable1437463takeable_
tales55451373t__a_les
talkable1437193talkable_
tamale83717403tama_le_
tamals84116633tama_l_s
tambalas1237033tambalas
tameable1238603tameable_
tangibles1243953tangibles
tangles83920043ta_ngles
tannable1039383tannable_
tapalos938813tapa_los
tapeable1238823tapeable_
tapholes1339623tapholes
tappable1436343tappable_
tastable101511973tastable_
tattles73616283ta_ttles
taxemes1635853tax_emes
taxes124730823tax___es
taxies135817333tax__ies
taxites1449673tax_ites
taxless1436913tax__less
taxols13328633tax_ol_s
tearable101512673tearable_
teasable101511173teasable_
teazles16308923t_eazles
tenable93214493tenable_
texases1437573texa_ses
textiles1536833textiles
thimbles1536023thimbles
timbales12227843timbales
totable92313363totable_
towable121910113towable_
tradable1139873tradable_
treacles1039703treacles
treadles939703treadles
trebles9311443t_rebles
trembles1237353trembles
triable92515393triable_
troubles1057203troubles
tumbles113816023t_umbles
tunable92511313tunable_
typable1435883typable_
valuables1442973valuables
variables1444673variables
vocables15145733vocables
wabbles144013993wa_bbles
wadable13310233wadable_
wambles143714023wa_mbles
warbles123215563wa_rbles
washables17144743washables
wearables14155003wearables

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.1561145455.1
2DLD Change Limit1461621267.06320694.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.26524596.1
 
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.