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

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
sensating103925(None) 
seating84130682se__ating
sedating103014112se_dating
seesawing1343652seesawing
sensation9510582sensation
sensations1059852sensations
sensing84116952sens__ing
seriating10916402seriating
serrating10513202serrating
sinuating1039682sinuating
aerating92821003ae_rating
beating104326873be__ating
benaming1339693ben_aming
bendaying1634953bendaying
berating113220763be_rating
besting104923923be_s_ting
censing104215263cens__ing
censoring1238783censoring
censuring1237603censuring
censusing1244813censusing
debating123213733de_bating
defeating142311973defeating
deflating142610713deflating
delating103119603de_lating
demasting1338453demasting
denoting10311753den_oting
denting94422183den__ting
denudating1345263denudating
derating103222283de_rating
desalting1138843de_salting
deviating14311083deviating
donating10311803don_ating
easting84924303_eas_ting
eating75134403_e__ating
elating83423083_e_lating
emendating1444613emendating
enacting11311363_enacting
encaging1258733_encaging
encasing11610823_encasing
enditing10311073_enditing
enfacing1467293_enfacing
engaging1147373_engaging
enlacing1148773_enlacing
enraging1049573_enraging
ensiling9410723_ensiling
enskying1633283_enskying
enslaving1345383_enslaving
ensnaring1046383_ensnaring
ensuing8239543_ens_uing
ensuring9310173_ensuring
enswathing1742683_enswathing
equating18310113_equating
essaying1235033_essaying
estating92614993_estating
feasting122011323feas_ting
fellating1339243fellating
gelating103015733ge_lating
gemmating1576443gemmating
generating12310383generating
gestating11229983gestating
heating114024323he__ating
heisting123411043heis_ting
hennaing1234993henna_ing
henting113719653hen__ting
herniating1445983herniating
instating10812213_instating
jesting154317713je_s_ting
legating102313113le_gating
leniting9312353len_iting
lensing84015103lens__ing
mandating1339773mandating
mediating13311203mediating
menacing1339783men_acing
mensing103915103mens__ing
messaging1345343messaging
negating102012833ne_gating
nesting84320443ne_s_ting
pulsating1236343pulsating
rebating112418343re_bating
recasting122414233recasting
recoating121317463recoating
recrating121318793recrating
redating102620173re_dating
reesting93118273rees_ting
reflating132514713reflating
regrating111316213regrating
reheating132314913reheating
reinstating1248113reinstating
relating92725443re_lating
remating112322413re_mating
renaming11313693ren_aming
renesting102514703renesting
renovating1447423renovating
renting84026853ren__ting
repasting122312843repasting
repeating122618983repeating
replating122217403replating
resawing122311433re_sawing
resaying122512453re_saying
reseating102421533reseating
resiting93521123re_siting
reslating102516993reslating
restating102319413restating
resting85031183re_s_ting
retasting102513413retasting
sandaling112010563sandaling
sanitating1149643sanitating
satiating10311803satiating
sating74735453___sating
scenting113212813scen__ting
seafaring1345963seafaring
sealing83528563se__aling
seaming103222113se__aming
searing83330923se__aring
seasoning1037413seasoning
seatings93614303se__atings
secreting1279823secreting
seising84018863seis__ing
selecting12310533selecting
sending94221373sen__ding
sensate7311893sensat__e
sensated938193sensat_ed
sensately1244283sensately
sensates8511143sensat_es
sensational1146383sensational
sensitise947293sensitise
sensitising1253773sensitising
sensitive1246963sensitive
sensitize1846563sensitize
sensitizing2155743sensitizing
separating1348643separating
sestina72711973se_s_tina
sestine73017923se_s_tine
setting83621393se__tting
situating1038883situating
skating123613853s__kating
slating83724653s__lating
snaking123915303s_n_aking
snaring83920953s_n_aring
snawing113612483s_n_awing
sneaking133211093s_neaking
sneaping11349493s_neaping
snooting92813203s_nooting
snorting92613373s_norting
snouting92511923s_nouting
solating9315593s_olating
solvating1336443solvating
sonatina849073son_atina
sonatine8313323son_atine
sonicating1348313sonicating
sonneting1037003sonneting
speciating1548123speciating
spectating1546623spectating
stating83725163s__tating
striating10914193striating
sublating12310983sublating
sulfating1338063sulfating
summating1437943summating
sunbathing1642933sunbathing
sweating123213023s_weating
tenanting1036213tenanting
tensing84616653tens__ing
tenting84621153ten__ting
testing86021053te_s_ting
unsaying1288153_unsaying
unseating10713203_unseating
unstating10711213_unstating
venenating1446013venenating
venerating14410053venerating
venting114218093ven__ting
vesting114618683ve_s_ting
westing115020273we_s_ting
yeasting12188923yeas_ting
zesting174515333ze_s_ting

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.406440125.6
2DLD Change Limit1486411746.59322545.3
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.06225303.2
 
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.