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

358 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
retasting10251341(None) 
pretasting13239281pretasting
recasting122414231recasting
repasting122312841repasting
retesting102614601retesting
breasting1239582bre_asting
demasting1338452demasting
detesting112610322detesting
easting84924302_e_asting
feasting122011322fe_asting
foretasting1554422foretasting
precasting15169832precasting
prepasting15168882prepasting
pretesting131810682pretesting
reacting113317892re_acting
rebaiting12311642rebaiting
rebating112418342reba_ting
recanting122414822recanting
redacting13612302redacting
redating102620172reda_ting
reesting93118272re_esting
rehashing1647112rehashing
relating92725442rela_ting
relisting102414352relisting
remating112322412rema_ting
renesting102514702renesting
repassing12249422repassing
resisting103215312resisting
restarting11310662restarting
restating102319412resta_ting
resting85031182re__sting
retacking1658972retacking
retagging1236032retagging
retailing103214732retailing
retaining102114732retaining
retaking133114282reta_king
retaping113012552reta_ping
retarding111110652retarding
retaxing162311332reta_xing
retinting102215252retinting
retorting10613272retorting
retracting13311932retracting
retting83425882ret__ting
retwisting1445632retwisting
revesting132814122revesting
rewashing1676902rewashing
roasting93012702r_oasting
rotating92614552rota_ting
tasting84624212__tasting
yeasting12188922ye_asting
aerating92821003aera_ting
attesting1036383attesting
basting104227203__basting
beastings12387653be_astings
beating104326873be_a_ting
bemisting1438073bemisting
berating113220763bera_ting
besting104923923be__sting
betaking153010153beta_king
betting103921403bet__ting
blasting114013433_blasting
boasting113512503_boasting
casting104628343__casting
ceasing104118263ce_as_ing
coasting113615513_coasting
creasing113314443cre_as_ing
creating113921953cre_a_ting
cremating14312193crema_ting
cresting114017043cre__sting
crevassing1643533crevassing
deashing134210953de_ashing
debasing12238063debas_ing
debating123213733deba_ting
decanting132510633decanting
defatting1436103defatting
degassing1234823degassing
degusting1236163degusting
delating103119603dela_ting
delisting112710503delisting
departing1349513departing
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desisting112810383desisting
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
detecting13259983detecting
detracting1438713detracting
devesting14249903devesting
distasting1248023distasting
easing74926463_e_as_ing
eastings93412953_e_astings
eating75134403_e_a_ting
egesting1039013_egesting
elastin72611843_elastin_
elastins82111743_elastins
elating83423083_ela_ting
enacting11311363_enacting
erasing8317963_eras_ing
estating92614993esta_ting
exacting1838523_exacting
exalting1638033_exalting
existing1639073_existing
fasting114522833__fasting
feasing113916653fe_as_ing
fetting113517873fet__ting
forecasting1744473forecasting
fretting122711523fret__ting
gasting95022763__gasting
gelating103015733gela_ting
gestating11229983gesta_ting
getting93316563get__ting
greasing102811393gre_as_ing
hasting114725193__hasting
hearting12513123he_arting
heating114024323he_a_ting
heisting123411043he_isting
impasting1436323impasting
jesting154317713je__sting
jetting153815343jet__ting
lasting84725243__lasting
leashing123310313le_ashing
leasing83920163le_as_ing
legating102313113lega_ting
letting83218533let__ting
levanting1345523levanting
masting104325823__masting
metaling111613723meta_ling
metalling1249593metalling
mutating112211753muta_ting
negating102012833nega_ting
nesting84320443ne__sting
netting84018763net__ting
notating92513343nota_ting
nutating92411953nuta_ting
obtesting1245883obtesting
outacting1239213outacting
outasking1437313outasking
outfasting1446333outfasting
outlasting1137523outlasting
outwasting1446433outwasting
pasting103826553__pasting
petting103720953pet__ting
preacting142412533pre_acting
predating13514653preda_ting
pretaping1439133preta_ping
pretexting20206973pretexting
prewashing1944943prewashing
protesting131910253protesting
rafting113815753r__afting
ranting84025413r__anting
rasing74330833r__as_ing
rasping104316253r__asping
rating74938703r__a_ting
ratting83822363r__atting
reaching143317203re_aching
readapting1445153readapting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
reaming103924013re_a_ming
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reasoning10310203re_asoning
reassign955423re_assign
reaving113820533re_a_ving
rebooting12139023rebooting
rebutting1237523rebutting
recalling122211903recalling
recaning111416693reca_ning
recapping1636453recapping
recessing12611013recessing
recharting1637213recharting
reciting113118073re_citing
reclasping15105083reclasping
recoating121317463recoating
recrating121318793recrating
recusing112512883recus_ing
recutting1239483recutting
redbaiting1446263redbaiting
redrafting1545963redrafting
reearning1039053reearning
reediting11310953reediting
reenacting1357353reenacting
refacing142512813refa_cing
refalling132010423refalling
refasten1136103refasten_
refastening1544303refastening
refastens1244753refastens
refecting152413353refecting
refitting132811123refitting
reflating132514713reflating
refracting1638733refracting
refusing122310873refus_ing
refuting121911903re_futing
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regrating
rehabbing1733653rehabbing
rehanging1437563rehanging
reheating132314913reheating
reissuing1034613reissuing
rejecting192211153rejecting
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relaxing162612633rela_xing
relaying122515153rela_ying
releasing10411013releas_ing
relenting102716773relenting
reletting102713943reletting
relishing13229183relishing
relucting1239773relucting
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remastering1446843remastering
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remising112516453remis_ing
remitting122412623remitting
renailing102813333renailing
renaming11313693rena_ming
renting84026853re__nting
repacking1838283repacking
repainting13128973repainting
repairing12310013repairing
reparking1638923reparking
repaving142810743repa_ving
repaying142712393repa_ying
repeating122618983repeating
repenting122316553repenting
replanting1338523replanting
replating122217403replating
reporting12513903reporting
reposing111213803repos_ing
repositing13310493repositing
repotting12511123repotting
reputing112412603re_puting
requesting2046313requesting
requiting1939883requiting
reracking1639313reracking
reraising10313773reraising
rerenting102617663rerenting
rerising93017783reris_ing
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433resa_wing
resaying122512453resa_ying
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
resifting133512093resifting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resorting10614613resorting
respiting121912863respiting
restabling1337653restabling
restacking1737183restacking
restaffing1744193restaffing
restaging112410853resta_ging
restamping1565213restamping
restring91518783re__string
resulting10311083resulting
retackling1744433retackling
retailings11265233retailings
retain64523283reta__in_
retains74522253reta__ins
retaliating1248873retaliating
retallying1464703retallying
retargeting1343933retargeting
retaste72313133retast__e
retasted92412113retast_ed
retastes82212903retast_es
retching143412173ret_ching
reteaching1636023reteaching
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retestify1543753retestify
retieing92913713ret_ieing
retiling93319483ret_iling
retiming113014193ret_iming
retiring92717413ret_iring
retitling1039773retitling
retooling1039093retooling
retracing12313293retracing
retracking1738163retracking
retraining11310243retraining
retreating111414773retreating
retroacting1447283retroacting
retrying122410453ret_rying
retsina74710603ret_s_ina
retuning9311583ret_uning
returning1038133returning
retying113213833ret__ying
retyping14255613ret_yping
reuniting10310693reuniting
reusing82516783re_us_ing
revaluing1337303revaluing
revamping1734633revamping
reverting132315133reverting
revetting132912633revetting
revising122714403revis_ing
revisiting1446953revisiting
revolting1339633revolting
revoting12312033re_voting
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewaxing19248563rewa_xing
rewetting132710443rewetting
rewriting13310413rewriting
riposting1236063riposting
roosting93411463r_oosting
rotting82919683rot__ting
rousting93913273r_ousting
rusting83821263r__usting
rutting82718043rut__ting
seating84130683se_a_ting
sedating103014113seda_ting
sensating1039253sensating
setting83621393set__ting
starting93116173_starting
stashing123511583_stashing
stating83725163_sta_ting
tarting84222653__tarting
tasking124616323__tasking
tatting84019523__tatting
tauting83316383__tauting
teasing83918513te_as_ing
tenanting1036213tenanting
testing86021053__testing
toasting93410583_toasting
treating92519613tre_a_ting
upcasting1434823upcasting
vesting114618683ve__sting
vetting114216563vet__ting
wasting114422843__wasting
webcasting1842483webcasting
westing115020273we__sting
wetting114117383wet__ting
wresting123811833wre__sting
zesting174515333ze__sting

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.423422437.4
2DLD Change Limit1486413586.58022589.8
3Display Results3583580.1532339.9
 (SQL Overall)1786913587.15624970.8
 
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.