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

363 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
refrying1527890(None) 
redrying13209021redrying
reflying15268171reflying
retrying122410451retrying
berrying14137372berrying
decrying15237412decrying
defraying1735852defraying
defying15328822def_ying
ferrying15146242ferrying
frying134511402__frying
herrying15147022herrying
predrying1645342predrying
readying13410222readying
rearing83128782rear_ing
rearming111413612rearming
reburying1535192reburying
rebuying1436742rebuying
refacing142512812refacing
referring1338032referring
reffing143712172ref_fing
refiling123116532refiling
refining122416862refining
refiring123513922refiring
refixing19329792refixing
reforging1437662reforging
reforming1538562reforming
refrain10310042refrain_
refrains1139592refrains
reframing1538622reframing
refuging13218422refuging
refusing122310872refusing
refuting121911902refuting
reifying1539382reifying
rekeying1637562rekeying
relaying122515152relaying
relying112914612re_lying
repaying142712392repaying
replying14269402replying
resaying122512452resaying
retying113213832re_tying
serrying12167692serrying
wearying1546702wearying
affraying1943103affraying
bearding124011943bearding
bearing103624773bear_ing
befringe1484513befr_inge
belaying143110603belaying
bellying14359073bellying
belying133612443be_lying
berming123614833be_rming
betraying1537713betraying
bewraying1834873bewraying
burying133413913_burying
carrying14148373carrying
cering94522533ce_r_ing
crying123612283__crying
currying14196493currying
dairying1336353dairying
decaying15239453decaying
decoying15208763decoying
defacing15238683defacing
defaming15238463defaming
deferring1436143deferring
defiling132812463defiling
defining133711803defining
deforcing1636063deforcing
deforming1636703deforming
defusing13227933defusing
defuzing22195253defuzing
deifying1637633deifying
delaying133210973delaying
denying123711293de_nying
descrying1635103descrying
drying113411603__drying
earing75235483_ear_ing
earning83418213_earning
earring83519013_earring
eddying1335293_eddying
envying1435713_envying
erring73816483_e_rring
espying1336193_espying
eying96117923_e__ying
faying134521073__faying
fearing113520033fear_ing
flying134612153__flying
fraying143413433__fraying
frenzying2542413frenzying
gearing92818843gear_ing
glorying1335543glorying
greying124110893gre__ying
harrying15157643harrying
hearing113324163hear_ing
hearsing1239383hearsing
hearting12513123hearting
hefting144510913hef_ting
heiring113312903heir_ing
herding122915123he_rding
herring113615883he_rring
hurrying15145533hurrying
jeering153513043jeer_ing
jellying19306173jellying
jemmying2332313jemmying
jerking19308923je_rking
jettying1933953jettying
jurying18337763_jurying
kerbing14308483ke_rbing
kerfing15307533ke_rfing
kerning124010893ke_rning
keying1438043ke__ying
learning978553learning
leering83417643leer_ing
leftwing1532973leftwing
levying1435873le_vying
marrying14157223marrying
merging112711763me_rging
metring103215293metr_ing
nearing83020333near_ing
nerving112910833ne_rving
panfrying1842993panfrying
parrying14168133parrying
pearling11912013pearling
peering103520353peer_ing
perking143716463pe_rking
perming123416093pe_rming
prearming14139223prearming
prebuying1734303prebuying
prefacing17118743prefacing
prefading16149033prefading
preferring1645623preferring
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
preforming1846233preforming
prepaying1747973prepaying
prettying1536043prettying
preying133114553pre__ying
prying124114803__prying
querying2135243querying
raffling1567063raffling
rafting113815753raf_ting
rallying12289013rallying
rarefying1654693raref_ying
raring74332873r_ar_ing
raying105027193r__aying
reaching143317203reaching
reacting113317893reacting
readding11411363readding
reading93327213re_ading
reaming103924013re_aming
reaping103621213re_aping
rearguing1135603rearguing
reaving113820533re_aving
rebating112418343rebating
rebodying1635003rebodying
reboring11312783reboring
rebuking1536693rebuking
recaning111416693recaning
recarrying1643653recarrying
receding122713763receding
reciting113118073reciting
recking144319923re_cking
recoding122213853recoding
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recrating121318793recrating
recurring1237953recurring
recurving1536773recurving
recusing112512883recusing
redating102620173redating
redding103218513re_dding
reddling112911813reddling
redefying1736093redefying
redenying1437783redenying
reding83825563re__ding
redoing93516733re_doing
redrawing1437213redrawing
redriving1437603redriving
reducing12310203reducing
redwing122811983re_dwing
redyeing1336173redyeing
reearning1039053reearning
reeding94124133re_eding
reedling102414273reedling
reefing114016863re_efing
reeking123318643re_eking
reeling83126863re_eling
reesting93118273reesting
reeving113717663re_eving
refalling132010423refalling
refecting152413353refecting
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
refencing15188853refencing
refereeing1444673refereeing
refilling13299333refilling
refilming15256463refilming
refind104717073ref__ind
refinding14259943refinding
refine95225693ref__ine
refitting132811123refitting
reflating132514713reflating
reflexing2035933reflexing
reflowing1636523reflowing
refluxing2034583refluxing
refolding1437453refolding
refracting1638733refracting
refrained1347223refrained
refrainer1245843refrainer
refraining1437263refraining
refreezing2344413refreezing
refreshing1746063refreshing
refried113513873refr_ied
refries104419733refr_ies
refront10313263refr_ont
refronting1437273refronting
refry114412463refry___
refueling13227973refueling
refunding14258073refunding
regaling10315363regaling
regarding12149153regarding
regiving13269713regiving
regluing1077033regluing
regorging1236823regorging
regrading121210203regrading
regrating111316213regrating
regrind938983regr_ind
regrowing1436673regrowing
rehiring122911883rehiring
reigning1039883reigning
reining84425323re_ining
reinking13311023reinking
reiving113316843re_iving
relacing112516043relacing
relating92725443relating
relaxing162612633relaxing
relining93218743relining
reliving122713343reliving
reluming11310013reluming
remaking152613303remaking
remarking1638893remarking
remarrying1643373remarrying
remating112322413remating
remedying1635143remedying
remerging1358323remerging
remising112516453remising
remixing182810333remixing
removing1439083removing
renaming11313693renaming
rending93924263re_nding
reneging102111533reneging
renewing121910713renewing
renting84026853re_nting
reoiling93217213reoiling
reparking1638923reparking
repaving142810743repaving
reperking1638703reperking
repining114116593repining
replaying15259603replaying
reporting12513903reporting
reposing111213803reposing
repping123314983re_pping
repricing14310473repricing
reprint9318983repr_int
reprising12312553reprising
reprobing1438073reprobing
reproving1538413reproving
reputing112412603reputing
rerig64018483re_r_i_g
rerising93017783rerising
resawing122311433resawing
rescuing1139623rescuing
reseeing92412623reseeing
reserving131110643reserving
resewing122712263resewing
residing103015473residing
resiling93520173resiling
resining92919553resining
resiting93521123resiting
resizing182714163resizing
resoling92916303resoling
resorbing1269353resorbing
resorting10614613resorting
resowing123111523resowing
respraying1636093respraying
respring111614063respring
resting85031183re_sting
restring91518783restring
restyling1337923restyling
resuming11310083resuming
resurging1138613resurging
retaking133114283retaking
retaping113012553retaping
retarding111110653retarding
retaxing162311333retaxing
retching143412173retching
retieing92913713retieing
retiling93319483retiling
retiming113014193retiming
retiring92717413retiring
retorting10613273retorting
retracing12313293retracing
retrain7615423retrain_
retrains8314533retrains
retting83425883re_tting
retuning9311583retuning
returning1038133returning
retyping14255613retyping
reusing82516783re_using
reveling123117083reveling
reverbing15248593reverbing
revering122918073revering
reversing132611483reversing
reverting132315133reverting
reviling122917213reviling
revising122714403revising
reviving152910503reviving
revoking1637803revoking
revoting12312033revoting
revving14379343re_vving
rewaking162310983rewaking
rewarding14148833rewarding
rewarming15147383rewarming
rewaxing19248563rewaxing
rewiring122911223rewiring
rewording14158543rewording
reworking17136873reworking
rewriting13310413rewriting
rezeroing1935933rezeroing
rezoning18310453rezoning
riffing144011273rif_fing
riffling1556113riffling
rifling112815013rif_ling
rifting113515003rif_ting
roaring82916003roar_ing
rubying13297933r_ubying
ruffing143210843ruf_fing
ruffling1546093ruffling
scrying1338663_scrying
searing83330923sear_ing
serging93416673se_rging
sering74731813se_r_ing
serving113014983se_rving
storying12249673storying
tarrying12146723tarrying
tearing84021493tear_ing
terming104016003te_rming
trying104214073__trying
updrying1534013updrying
varying1429723_varying
veering113213683veer_ing
verging123812303ve_rging
versing112314193ve_rsing
wearing113318863wear_ing
weirding1335593weirding
wherrying1952993wherrying
worrying1534703worrying
wrying13379623__wrying
yearling1297883yearling
yearning1296983yearning
yerking15368813ye_rking
zeroing1738343ze_roing

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623637.40619735.6
3Display Results3633630.1402592.9
 (SQL Overall)1786913637.95222471.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.