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

280 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
reearning103905(None) 
relearning1135281relearning
earning83418212__earning
learning978552_learning
prewarning16135192prewarning
rearing83128782r_ear_ing
rearming111413612r_earming
recaning111416692reca_ning
regaining112411082regaining
regarding12149152regarding
regearing112211412regear_ing
rehearing132211762rehear_ing
rehearsing1444342rehearsing
remaining122212792remaining
remanning12229032remanning
remarking1638892remarking
reparking1638922reparking
retaining102114732retaining
retarding111110652retarding
retearing102214252retear_ing
returning1038132returning
rewarding14148832rewarding
rewarming15147382rewarming
rewearing132310702rewear_ing
yearning1296982_yearning
anearing9413973anear_ing
barning104320353__barning
beaning103820683_bea_ning
bearding124011943_bearding
bearing103624773_bear_ing
bedamning1534183bedamning
beelining1236593beelining
bemeaning1436193bemea_ning
bewaring14279493bewar_ing
bewearying1942293bewearying
blearing113111943blear_ing
cleaning113112383clea_ning
clearing113014883clear_ing
clearwing1533673clearwing
darning93817333__darning
deaning94020473_dea_ning
debarking1735383debarking
debarring1335713debarring
debearding1543733debearding
decerning1337293decerning
deepening1335613deepening
dehorning1455243dehorning
demarking1736773demarking
demeaning1337243demea_ning
departing1349513departing
detaining112510473detaining
earing75235483__ear_ing
earnings9419333__earnings
earring83519013__earring
fearing113520033_fear_ing
forewarning1842783forewarning
gearing92818843_gear_ing
gleaning10269323glea_ning
greening103112533gree__ning
hearing113324163_hear_ing
hearsing1239383_hearsing
hearting12513123_hearting
jeering153513043jee_r_ing
keening123713153kee__ning
kerning124010893_ke_rning
leaning83721203_lea_ning
learnings1094323_learnings
leering83417643lee_r_ing
meaning103918703_mea_ning
nearing83020333_near_ing
nonearning1145183nonearning
outearning1146743outearning
pearling11912013_pearling
peening103318303pee__ning
peering103520353pee_r_ing
prearming14139223prearming
preening113115843pree__ning
preparing14311643prepar_ing
prewarming18145173prewarming
preweaning1645633prewea_ning
raining83922693r__aining
raring74332873r__ar_ing
reaching143317203r_eaching
reacting113317893r_eacting
readding11411363r_eadding
reading93327213r_ea_ding
readorning1245723readorning
readying13410223r_eadying
reaming103924013r_ea_ming
reaping103621213r_ea_ping
rearguing1135603r_earguing
reasoning10310203reasoning
reaving113820533r_ea_ving
rebaiting12311643rebaiting
rebating112418343reba_ting
reboarding1445673reboarding
reboring11312783rebor_ing
reburying1535193reburying
recalling122211903recalling
recanting122414823recanting
recapping1636453recapping
recarrying1643653recarrying
recasting122414233recasting
recharging1745293recharging
recharting1637213recharting
reckoning1637643reckoning
recleaning1336753reclea_ning
reclining121112283reclining
recoining121313803recoining
reconning121410793reconning
recording131311623recording
recorking16149643recorking
recrating121318793recrating
recurring1237953recurring
recurving1536773recurving
redacting13612303redacting
redarguing1342863redarguing
redating102620173reda_ting
reddening1237433reddening
redefining1545423redefining
redlining111210293redlining
redonning11127643redonning
redrawing1437213redrawing
redrying13209023r_edrying
reearn6612143reear__n_
reearned948883reearn_ed
reearns749103reear__ns
reechoing1545293reechoing
reeding94124133ree__ding
reediting11310953reediting
reedling102414273ree_dling
reefing114016863ree__fing
reeking123318643ree__king
reeling83126863ree__ling
reembarking2042673reembarking
reemerging1474583reemerging
reenacting1357353reenacting
reenlarging1342473reenlarging
reesting93118273ree_sting
reeving113717663ree__ving
reevoking1734223reevoking
reexamining2152663reexamining
refacing142512813refa_cing
refalling132010423refalling
referring1338033referring
refining122416863r_efining
refiring123513923refir_ing
reforging1437663reforging
reforming1538563reforming
refraining1437263refraining
reframing1538623reframing
refrying15278903r_efrying
regaling10315363rega_ling
regauging1235543regauging
regorging1236823regorging
regrading121210203regrading
regranting1238323regranting
regrating111316213regrating
rehabbing1733653rehabbing
rehanging1437563rehanging
rehardening1644143rehardening
rehashing1647113rehashing
rehearings14214573rehear_ings
reheating132314913rehea_ting
rehiring122911883rehir_ing
reigning1039883r_eigning
reining84425323r_e_ining
rejoining17149223rejoining
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
releasing10411013relea_sing
relining93218743r_elining
reloaning10710483reloaning
remailing122412473remailing
remaking152613303rema_king
remanding132211143remanding
remapping1635023remapping
remarrying1643373remarrying
remating112322423rema_ting
remerging1358323remerging
renailing102813333renailing
renaming11313693rena_ming
renowning1336083renowning
reopening1248823reopening
repacking1838283repacking
repainting13128973repainting
repairing12310013repairing
repassing12249423repassing
repasting122312843repasting
repaving142810743repa_ving
repaying142712393repa_ying
repealing122513543repea_ling
repeating122618983repea_ting
reperking1638703reperking
repining114116593r_epining
repinning12258973repinning
replanning1345313replanning
reporting12513903reporting
repugning1335863repugning
reracking1639313reracking
reraising10313773reraising
rereading111212713rerea_ding
rerunning1036523rerunning
resailing103314253resailing
resawing122311433resa_wing
resaying122512453resa_ying
resealing102115673resea_ling
researching1743423researching
reseasoning1243003reseasoning
reseating102421533resea_ting
reserving131110643reserving
reshining13310743reshining
resigning1139463resigning
resining92919553r_esining
resorbing1269353resorbing
resorting10614613resorting
respring111614063respr_ing
restarting11310663restarting
restring91518783restr_ing
resurging1138613resurging
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retaking133114283reta_king
retaping113012553reta_ping
retasting102513413retasting
retaxing162311333reta_xing
reteaching1636023reteaching
reteaming122110443retea_ming
retiring92717413retir_ing
retorting10613273retorting
retracing12313293retracing
retraining11310243retraining
retrying122410453r_etrying
retuning9311583r_etuning
revaluing1337303revaluing
revamping1734633revamping
revarnish1543933revarnish
revealing132611883revea_ling
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rewakening1843793rewakening
rewaking162310983rewa_king
rewashing1676903rewashing
rewaxing19248563rewa_xing
reweaving16227073rewea_ving
rewinning13257443rewinning
rewiring122911223rewir_ing
rewording14158543rewording
reworking17136873reworking
rezeroing1935933rezeroing
rezoning18310453r_ezoning
roaring82916003r_oar_ing
searing83330923_sear_ing
secerning1246203secerning
shearing123915903shear_ing
shearling1336923shearling
smearing113511753smear_ing
speaning113512243spea_ning
spearing113216103spear_ing
swearing123711443swear_ing
tearing84021493_tear_ing
trepanning1344153trepanning
unlearning1144713unlearning
veering113213683vee_r_ing
warning113717093__warning
weaning114117193_wea_ning
wearing113318863_wear_ing
wearying1546703_wearying
weening114113973wee__ning
yarning113512953__yarning
yeaning113814633_yea_ning
yearling1297883_yearling
yearnings1393553_yearnings

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 Limit1486412807.19020673.3
3Display Results2802800.1232276.4
 (SQL Overall)1786912807.73323107.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.