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

114 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
tableting123635(None) 
tabletting1344091tabletting
ablating11312002_ablating
galleting1137632galleting
palleting1238742palleting
rabbeting1445182rabbeting
tabering112211422tab_ering
tabling103216032tabl__ing
tabulating1346432tabulating
targeting1137302targeting
toileting1036262toileting
valeting1238852va_leting
abating10413973_ab_ating
abetting1158293_abetting
aborting11710253_aborting
absenting1236993_absenting
abutting1137003_abutting
alerting91312383_a_lerting
alleging1038473_alleging
balloting1238393balloting
basseting1236153basseting
belting104119133__belting
billeting1236643billeting
bleating113514503__bleating
bulleting1236643bulleting
cabling124017553cabl__ing
cacheting1737153cacheting
carpeting1439483carpeting
casketing1635383casketing
colleting12311063colleting
deleting103314423_deleting
depleting1378193depleting
embleming1644433embleming
fabling133413623fabl__ing
fabulating1645523fabulating
faceting1438783fa_ceting
faulting12237733faul_ting
fileting1239303_fileting
filleting1335853filleting
gabling113514543gabl__ing
gantleting1243913gantleting
gibbeting1542903gibbeting
gimleting1343863gimleting
habiting1437533hab_iting
halting114419073ha_l_ting
jabbering2134443jabbering
jacketing2345643jacketing
labeling11311653lab_eling
labelling1238093labelling
leafleting1442893leafleting
malting103219083ma_l_ting
marketing1636513marketing
packeting1836853packeting
pargeting1338283pargeting
parleying1536113parleying
pelleting1237953pelleting
rabbiting1445033rabbiting
racheting1537793racheting
racketing1647873racketing
sabeing102611863sab_e_ing
sabering112113743sab_ering
salting84120793sa_l_ting
saluting9310553sa_luting
stabling112913653stabl__ing
sublating12310983sublating
subletting1346273subletting
tabbing123611913tab__bing
tabbying1633973tab_bying
tabetic1138463tab_eti_c
tabetics1245683tab_etics
tableland1242973tableland
tablet84227643tablet___
tableted1137533tablet_ed
tabletop1243413tablet_op
tabletops1342943tabletops
tablets94714383tablet__s
tabletted1244833tabletted
tabooing11186313tab_ooing
taboring113010193tab_oring
tabouring1245723tabouring
tabuing10308893tab__uing
tailgating1244913tailgating
tailing82923103tail__ing
tailoring1036403tailoring
tainting93613583ta_inting
talcing103111633ta_l_cing
talcking1567083ta_lcking
talking123815823ta_l_king
tallaging1146503tallaging
tallowing1366293tallowing
tallying12318833ta_llying
tampering1438453tampering
tapering112112503ta_pering
tarletan845543tarletan_
tarletans944653tarletans
tarting84222653ta__rting
tasseling1035853tasseling
tasting84624213ta__sting
tattering102212333tattering
tatting84019523ta__tting
taunting93510933ta_unting
tautening1035843tautening
tauting83316383ta__uting
telexing1646613t_elexing
telneting1035593telneting
ticketing1635633ticketing
tillering1037883tillering
tilting83417103t_il_ting
trailering1145723trailering
tubulating1345593tubulating
tweeting12267033t_weeting
unbelting1237663unbelting
vaulting12227233vaul_ting
yabbering1734023yabbering

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411146.61022487.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.07625253.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.