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

306 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
regeared103943(None) 
beggared1334752beggared
dogeared1145792dogeared
geared85317742__geared
reared75930012r__eared
reearned948882re_earned
referred1297832referred
regaled93615962reg_aled
regard85215772reg_ar_d
regarded11279802reg_arded
regear73512742regear__
regears83012462regear_s
regelated1139722regelated
reglazed1935742reglazed
regraded113410762regraded
regrated102816332regrated
reheard11309022rehear_d
rehearsed13305912rehearsed
reheated122415002reheated
relearned1035632relearned
released9310242released
repealed113211872repealed
repeated113117442repeated
resealed92713962resealed
reseated93220262reseated
reteamed1138012reteamed
revealed123211212revealed
revered112819332reve_red
reweaved1535952reweaved
rogered939552roge_red
afeared1176833_afeared
aneared8512743_aneared
angered93013473ange_red
appeared1336143appeared
begazed2036203beg_azed
beheaded1536373beheaded
beleaped1336103beleaped
bemeaned1335783bemeaned
bereaved1446403bereaved
besmeared1443423besmeared
bewared13310113be_wared
bewearied1544203bewearied
bleared104211253_bleared
cellared11398793cellared
cleared103612463_cleared
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
deceased1247713deceased
declared1248743declared
defeated132812163defeated
deferred13106363deferred
degermed1335453degermed
deglazed2034953deglazed
degraded12288323degraded
degreased1244713degreased
deleaded1148333deleaded
deleaved1346573deleaved
demeaned1237283demeaned
deterred10137803deterred
eared65139503___eared
egested938123_egested
endeared1038053endeared
feared106320433__feared
fevered14339723feve_red
glared84715193__glared
jeered143912793je_e_red
lagered92311153lage_red
leered73816223le_e_red
legated92513983leg_ated
levered114212303leve_red
metered103514013mete_red
neared75119803__neared
negated93413233neg_ated
peered93819483pe_e_red
petered103314963pete_red
precleared1544103precleared
preferred1555003preferred
preheated1539813preheated
prepared132210863pre_pared
rared65738323r___ared
reamed94326123r__eamed
reaped94122453r__eaped
reappeared1543013reappeared
rearer64928913r__earer
rearmed103912823r__earmed
reaved104523923r__eaved
reawaked16366623reawaked
rebated103619703re_bated
rebelled113110323rebelled
reboard10310763reboar_d
reboarded1365613reboarded
rebored105015883re_bored
rebred95816353r__ebred
recaned102817203re_caned
receded112713043rece_ded
received1437983received
recessed1139713recessed
recharged1656333recharged
recharted1557563recharted
recleaned1236583recleaned
recoaled113111783recoaled
recoated113416783recoated
recrated112918593recrated
recreated12412533recreated
recurred1137093recurred
redated93120923re_dated
redear73515173redear__
redears82814453redear_s
redeemed1235593redeemed
redefied1368223redefied
redenied10511283redenied
redheaded1545083redheaded
redialed10310793redialed
redreamed1345023redreamed
redware1139353redware_
redwares1239053redwares
reearn6612143re_ear_n
reearns749103re_earns
reeded84022563re_e_ded
reefed103816583re_e_fed
reeked113717643re_e_ked
reeled74725533re_e_led
reested82916233re_ested
reeved104118713re_e_ved
refaced133713573re_faced
refected142311663refected
refeed104717623refe__ed
refelled122810163refelled
refenced1438993refenced
referee101615753refe_ree
refereed12149693refereed
referrer11136053referrer
refired115116993re_fired
reflated123514293reflated
reframed1437853reframed
regained102111243regained
regale74821453reg_ale_
regaler83814623reg_aler
regales83520793reg_ales
regards94112563reg_ards
regauged1135143regauged
regave104713383reg_ave_
regearing112211413regearing
regelate9312083regelate_
regelates10311113regelates
reggae858953regga_e_
reggaes948883regga_es
regilded1135543regilded
reglaze1747223reglaze_
reglazes1846793reglazes
reglowed13125853reglowed
reglued936333reg_lued
regorged11227333regorged
regrade92612033regrade_
regrades103212173regrades
regrafted1435243regrafted
regranted1137703regranted
regrate82618663regrate_
regrates92618393regrates
regreened1145553regreened
regreeted1136173regreeted
regressed1138113regressed
regret73723533reg__ret
regretted1137233regretted
regrew10388563reg__rew
regulated11310463regulated
rehear93713223rehear__
rehears103312773rehear_s
rehearse11296653rehearse
rehearser12265023rehearser
rehearses12286843rehearses
reheater113413033reheater
reheeled1236763reheeled
rehemmed1634153rehemmed
rehired115013153re_hired
reimaged1246173reimaged
rejected182710113rejected
rekeyed1536163reke_yed
relaced103517213re_laced
related83327573re_lated
relaxed153312523re_laxed
relayed113212753re_layed
relearn747973relear_n
relearns836303relearns
relearnt849213relearnt
release7312763release_
releaser839503releaser
releases8313343releases
relegated1139763relegated
relented92614943relented
reloaded1059103reloaded
reloaned939723reloaned
remarked15209243re_marked
remated103522473re_mated
remeasured1343053remeasured
remedied1237953remedied
remelted11310153remelted
remended123010393remended
remerged12149173remerged
renamed103114523re_named
rendered102512263rendered
renegaded1244603renegaded
reneged92010763rene_ged
renested92212953renested
renewed11309993rene_wed
repaired1148953repaired
reparked15208923re_parked
repaved133311133re_paved
repealer103210703repealer
repeater102615443repeater
repegged1334883repegged
repelled113111573repelled
repented112614983repented
reperked15177793reperked
replaced133211393replaced
replated112817513replated
replayed14248623replayed
repleaded1336283repleaded
repoured1139563repoured
required18156833required
reread71715433rerea__d
rerented92516163rerented
rereward1246133rerewar_d
resawed113111183re_sawed
rescaled113311303rescaled
rescored114513103rescored
research1344553research
researched1643433researched
resected112514743resected
resecured1245533resecured
reseed74823293rese__ed
reseeded1038093reseeded
reseized1839213reseized
resented92716963resented
reserved121010583reserved
resewed113011823rese_wed
reshaped1437203reshaped
reshaved1536873reshaved
reslated93517523reslated
resoaked1337943resoaked
respaced1338503respaced
respaded1238133respaded
respired1148993respired
restaged103011863restaged
restarted10410053restarted
restated93120183restated
restored96417193restored
retaped103814283re_taped
retard75018933re_tar_d
retarded102410753re_tarded
retaxed153512233re_taxed
retear63115483retear__
retears72814923retear_s
retested92212533retested
retired84620143re_tired
retraced111413023retraced
retreaded1137053retreaded
retreated10312623retreated
revealer113110073revealer
reveled113917753reve_led
revelled123712733revelled
revenged1337553revenged
revenued1237223revenued
reverbed14269223reverbed
revere94621253reve_re_
reverend12288853reve_rend
reverer103815833reve_rer
reveres103621343reve_res
reversed122711613reversed
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewaked153811903re_waked
reward106017633re_war_d
rewarded13229523re_warded
rewarmed14257433re_warmed
rewaxed18409343re_waxed
rewear93011993rewear__
rewears102911033rewear_s
reweave1336773reweave_
reweaves1436603reweaves
rewedded1434513rewedded
rewelded1335893rewelded
rewetted12228353rewetted
rewired115413283re_wired
reynard1135123reynar_d
rezeroed1835993rezeroed
roared75015393r__oared
saggared11326063saggared
seared75232843__seared
severed113513863seve_red
sewered112911243sewe_red
sheared114516003_sheared
smeared104510623_smeared
speared104314423_speared
sugared938583sug_ared
teared75722153__teared
unbeared111611653unbeared
unfeared121511013unfeared
unseared91113943unseared
upreared1137073upreared
veered103612743ve_e_red
vegetated1445083vegetated
veneered1235983veneered
wagered12299333wage_red

Search took 9 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.1731032896.0
2DLD Change Limit1461623068.61016975.8
3Display Results3063060.1232487.8
 (SQL Overall)1786913068.90620064.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.