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

150 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
tableted113753(None) 
tabletted1244831tabletted
ablated102513442_ablated
abluted10188362_abluted
galleted1038212galleted
palleted1139872palleted
rabbeted1334442rabbeted
tabered103311592tab_ered
tabled94020042tabl__ed
tablet84227642tablet__
tabletop1243412tabletop
tablets94714382tablet_s
tabulated1237302tabulated
talented938422ta_lented
targeted1037482targeted
toileted936992toileted
valeted1139012va_leted
abated95918453_ab_ated
abetted1058323_abetted
ablate82219213_ablate_
ablates92416903_ablates
abled86926833_abl__ed
aborted10310423_aborted
absented1156613_absented
abutted1056983_abutted
alated75625143_a_lated
alerted82512223_a_lerted
alleged9389323_alleged
athlete1068083athlete_
athletes1157883athletes
balloted1189043balloted
basseted1136743basseted
belted94020633__belted
billeted1137643billeted
bleated104015973__bleated
bleed85019803__ble_ed
bulleted1138393bulleted
cabled114819873cabl__ed
cablet104429463cablet__
cablets114216343cablet_s
cacheted16148233cacheted
carpeted1338953carpeted
casketed1534953casketed
chapleted1743973chapleted
colleted113011663colleted
deleted93314913_deleted
depleted12258723depleted
emblemed1544273emblemed
fabled124216383fabl__ed
fabulated1546323fabulated
faceted13509563fa_ceted
faulted11227723faul_ted
fileted1159093_fileted
filleted1236603filleted
gabelled12317583gabelled
gabled105518453gabl__ed
galeated104111573ga_leated
gantleted1144393gantleted
garreted1057523garreted
gibbeted1492783gibbeted
gimleted1243973gimleted
habited1337883hab_ited
halted105019603ha_l_ted
isleted837523_isleted
jabbered2034433jabbered
jacketed22146533jacketed
labeled102510563lab_eled
labelled11278293labelled
labiated11109303labiated
lanceted1137073lanceted
lappeted13255833lappeted
leafleted1342893leafleted
malted94819863ma_l_ted
marketed1537323marketed
packeted17148283packeted
pargeted1238683pargeted
parleyed1436243parleyed
pelleted1138203pelleted
rabbited1334763rabbited
racheted14149503racheted
racketed15169123racketed
sabered103213023sab_ered
sacheted14127833sacheted
salted74121203sa_l_ted
saluted84511713sa_luted
stabled103514953stabl__ed
stablemen1343923stablemen
sublated11311503sublated
tabarded1234743tabarded
tabbed114215363tab__bed
tabbied12297793tab_bied
tabetic1138463tab_etic
table75429603tabl__e_
tableau966283table_au
tableaus1054853tableaus
tableaux1772863tableaux
tableful1344183tableful
tableland1242973tableland
tableless1145033tableless
tablemate1344833tablemate_
tablemates1444693tablemates
tables84524893tabl__es
tableting1236353tableting
tabletops1342943tabletops
tabloid1048263tabl_oid
tabooed10267383tab_ooed
tabored102810563tab_ored
taboured1156273taboured
tabued94310403tab__ued
tabulate10310893tabulate_
tabulates1139143tabulates
tailed74424663tail__ed
tailgated1145133tailgated
tailored936203tailored
tainted83512423ta_inted
talced93811003ta_l_ced
talcked1446343ta_lcked
taliped1078203ta_liped
talked114015403ta_l_ked
tallaged10257923tallaged
tallied83314753ta_llied
tallowed12157713tallowed
taloned8310223ta_loned
tampered13279463tampered
tapered102612933ta_pered
tarletan845543tarletan
tarted74923373ta__rted
tarweed1137343tarwe_ed
tasseled935593tasseled
tasted74123973ta__sted
tatted74920533ta__tted
tattered92011443tattered
taunted84310963ta_unted
tauted75317113ta__uted
tautened935423tautened
telexed1536323t_elexed
telneted935073telneted
ticketed15146643ticketed
tillered937443tillered
tilted74616863t_il_ted
trabeated1246843trabeated
trailered1045393trailered
tubulated1256063tubulated
turreted935373turreted
tweeted11336583t_weeted
unbelted1179333unbelted
valleyed1534013valleyed
vaulted11307193vaul_ted
walleyed1534153walleyed
yabbered1633963yabbered

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.440406115.9
2DLD Change Limit1461621507.56019333.6
3Display Results1501500.0503000.0
 (SQL Overall)1786911508.05022197.6
 
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.