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

322 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
retaining10211473(None) 
detaining112510471detaining
regaining112411081regaining
remaining122212791remaining
retailing103214731retailing
retraining11310241retraining
attaining1047222attaining
destaining1267942destaining
detailing112510412detailing
detraining1267672detraining
obtaining1236772obtaining
pertaining1347992pertaining
pretraining1446502pretraining
raining83922692r__aining
reattaining1244592reattaining
rebaiting12311642rebaiting
recaning111416692reca_ning
reclining121112282reclining
recoining121313802recoining
redlining111210292redlining
reearning1039052reearning
refining122416862re_fining
refraining1437262refraining
reining84425322re__ining
rejoining17149222rejoining
relining93218742re_lining
remailing122412472remailing
remanning12229032remanning
renailing102813332renailing
reobtaining1443532reobtaining
repainting13128972repainting
repairing12310012repairing
repining114116592re_pining
reraising10313772reraising
resailing103314252resailing
reshining13310742reshining
resining92919552re_sining
restraining1247532restraining
retacking1658972retacking
retagging1236032retagging
retailings11265232retailings
retaking133114282reta_king
retaping113012552reta_ping
retarding111110652retarding
retasting102513412retasting
retaxing162311332reta_xing
rethinking1845182rethinking
retieing92913712ret_ieing
retiling93319482ret_iling
retiming113014192ret_iming
retinting102215252ret_inting
retiring92717412ret_iring
retuning9311582ret_uning
returning1038132returning
staining9413372_staining
abstaining1344573abstaining
attainting1144783attainting
beaning103820683be_a_ning
bedamning1534183bedamning
beelining1236593beelining
bepainting15144883bepainting
betaking153010153beta_king
bethinking2044043bethinking
betiding1239913bet_iding
bewailing1536063bewailing
braining113414683_braining
captaining1546073captaining
chaining142810783_chaining
containing13410933containing
creatinine1245073creatinine
curtaining1345533curtaining
deairing10311893de_airing
deaning94020473de_a_ning
declining13129353declining
defining133711803de_fining
depainting14156153depainting
deraigning1344103deraigning
derailing112011313derailing
destining11311433destining
detaching1637263detaching
detailings12243923detailings
deveining1436393deveining
distaining1248903distaining
draining103312673_draining
earning83418213_e_arning
eloining9310443_eloining
emailing113010043_emailing
engining1039293_engining
entailing1039393entailing
entraining1147643entraining
entwining1345423entwining
examining1945143_examining
gaining94015663__gaining
graining102813183_graining
greatening1245443greatening
intwining1345883intwining
leaning83721203le_a_ning
learning978553le_arning
meaning103918703me_a_ning
metaling111613723meta_ling
metalising1348943metalising
metalizing22511363metalizing
metalling1249593metalling
mutining11310493mut_ining
neatening1038353neatening
ordaining1145753ordaining
outgaining1237093outgaining
outlining10310503outlining
paining103920243__paining
patining11312303pat_ining
peining104619153pe__ining
plaining113911553_plaining
preobtaining1752533preobtaining
pretaping1439133preta_ping
pretasting13239283pretasting
prevailing1656723prevailing
prewarning16135193prewarning
raiding93617593r__aiding
railing83325643r__ailing
raising83220533r__aising
rationing1039783rationing
ratooning1037173ratooning
rattening10288763rattening
ravining12269693r_avining
reaching143317203re_aching
reacting113317893re_acting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
realigning1245933realigning
realising10313173realising
realizing19313813realizing
reaming103924013re_a_ming
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reasoning10310203reasoning
reavailing1444873reavailing
reaving113820533re_a_ving
rebating112418343reba_ting
rebinding13249483re_binding
reboiling12149823reboiling
recalling122211903recalling
recanting122414823recanting
recapping1636453recapping
recasting122414233recasting
receiving1538993receiving
reciting113118073re_citing
reckoning1637643reckoning
reclaiming1546583reclaiming
recoiling121412413recoiling
reconning121410793reconning
redacting13612303redacting
redating102620173reda_ting
redbaiting1446263redbaiting
reddening1237433reddening
redefining1545423redefining
redialing11311843redialing
redlinings12132793redlinings
redonning11127643redonning
redriving1437603redriving
reediting11310953reediting
reexamining2152663reexamining
refacing142512813refa_cing
refalling132010423refalling
refiling123116533re_filing
refinding14259943re_finding
refiring123513923re_firing
refixing19329793re_fixing
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regiving13269713re_giving
regrinding1335703regrinding
rehabbing1733653rehabbing
rehanging1437563rehanging
rehashing1647113rehashing
rehinging1437453re_hinging
rehiring122911883re_hiring
reigning1039883re_igning
reimagining1542663reimagining
reinking13311023re__inking
reiving113316843re__iving
rejoicing19136943rejoicing
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
relearning1135283relearning
relinking1458253re_linking
reliving122713343re_living
reloaning10710483reloaning
relumining1345643relumining
remaking152613303rema_king
remanding132211143remanding
remapping1635023remapping
remarking1638893remarking
remating112322413rema_ting
reminding132311543re_minding
reminting122315103re_minting
remising112516453re_mising
remixing182810333re_mixing
renaming11313693rena_ming
renowning1336083renowning
reoiling93217213re_oiling
reopening1248823reopening
reordaining1343453reordaining
repacking1838283repacking
reparking1638923reparking
repassing12249423repassing
repasting122312843repasting
repaving142810743repa_ving
repaying142712393repa_ying
repinning12258973repinning
replanning1345313replanning
repricing14310473repricing
reprinting131510583reprinting
reprising12312553reprising
repugning1335863repugning
requiring1937043requiring
requiting1939883requiting
reracking1639313reracking
rerising93017783re_rising
rerunning1036523rerunning
resawing122311433resa_wing
resaying122512453resa_ying
rescinding1436723rescinding
reseizing19311233reseizing
residing103015473re_siding
resigning1139463resigning
resiling93520173re_siling
resiting93521123re_siting
resizing182714163re_sizing
respiring12159903respiring
respiting121912863respiting
restabling1337653restabling
restacking1737183restacking
restaffing1744193restaffing
restaging112410853resta_ging
restamping1565213restamping
restarting11310663restarting
restating102319413resta_ting
restationing1354263restationing
restriking1548043restriking
restringing1345713restringing
restriving1448133restriving
retackling1744433retackling
retailoring1243733retailoring
retain64523283reta__in_
retained93016093retain_ed
retainer82913813retain_er
retainers92510763retainers
retains74522253reta__ins
retaliating1248873retaliating
retallying1464703retallying
retching143412173ret_ching
reteaching1636023reteaching
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retesting102614603retesting
retinene839803ret_inene
retinite8314853ret_inite
retitling1039773retitling
retooling1039093retooling
retorting10613273retorting
retracing12313293retracing
retracking1738163retracking
retracting13311933retracting
retrieving1445293retrieving
retrimming1544263retrimming
retrying122410453ret_rying
retting83425883ret__ting
retwisting1445633retwisting
retying113213833ret__ying
retyping14255613ret_yping
reuniting10310693reuniting
revaluing1337303revaluing
revamping1734633revamping
reviling122917213re_viling
revising122714403re_vising
reviving152910503re_viving
revoicing15117713revoicing
rewakening1843793rewakening
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
rewinding14238933re_winding
rewinning13257443rewinning
rewiring122911223re_wiring
rewriting13310413rewriting
rezoning18310453re_zoning
rosining92411423r_osining
rotating92614553rota_ting
ruining83514883r__uining
saining83621393__saining
seining84020773se__ining
sequining1945323sequining
spraining1248153spraining
staning83922243_sta_ning
straining10410563straining
sustaining1145883sustaining
tailing82923103__tailing
tainting93613583__tainting
tanning83618253__tanning
tetanising1146173tetanising
tetanizing2068093tetanizing
tining74927543__t_ining
training93015863_training
trepanning1344153trepanning
trephining1644933trephining
trining82919213__trining
twining113211443__twining
untwining1346303untwining
veining114713893ve__ining
weaning114117193we_a_ning
yeaning113814633ye_a_ning
yearning1296983ye_arning

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 Limit1486413226.59322545.3
3Display Results3223220.1562064.1
 (SQL Overall)1786913227.17224915.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.