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

531 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
reigned94921(None) 
deigned1037501deigned
feigned1245351feigned
reined74425521rei_ned
resigned1038861resigned
aligned9128552aligned
beigne9148612beigne_
beignes10149242beignes
beignet101510962beignet
coigned11418662coigned
designed1136942designed
feigner1135592feigner
neighed12135892neighed
peined94918842pei_ned
rained75024602rai_ned
realigned1145332realigned
recaned102817202recaned
refined114720002refined
rehinged1336852rehinged
reified112913782reified
reign65015192reign__
reignited1145682reignited
reigns74811752reign_s
reinked1239792reinked
reived104518132rei_ved
rejigged1833682rejigged
relined85321932relined
renigged1135052renigged
repined104918772repined
repinned1157472repinned
repugned1235352repugned
rerigged1136242rerigged
resigner937792resigner
resined84522652resined
retuned86613972retuned
rezoned173611162rezoned
rigged94517402r_igged
ringed84623842r_inged
ruined74813322rui_ned
seined74023062sei_ned
signed83413752_signed
veined104413912vei_ned
weighed15135932weighed
aliened81011743aliened
aligner8108303aligner
alined75221403ali_ned
arraigned11103033arraigned
assigned1044633assigned
beaned95621473be_aned
begged115013803be_gged
beige81515373beig_e_
beiges91014403beig_es
beignets11155373beignets
beringed1298173beringed
bewigged1643383bewigged
bewinged1584473bewinged
binged105920823_binged
binned94414543_binned
brained103816103brai_ned
brined95118413bri_ned
cairned1037643cairned
ceiled94114953cei_led
chined125620063chi_ned
chinned134810493chinned
clinged113310093clinged
coigne94612193coigne_
coignes103912153coignes
coined94523603coi_ned
cosigned1235723cosigned
cringed113312403cringed
deaned84620453de_aned
deboned113411633deboned
defined123813823defined
deiced104214483dei_ced
deified123112413deified
deign74312803deign__
deigns8389983deign_s
denned84215633de_nned
deponed113712873deponed
deraigned1244093deraigned
designee1087753designee
designer1036543designer
digged104314653_digged
dined76431993_di_ned
dinged95221783_dinged
dinned84317613_dinned
drained93713253drai_ned
dredged11346883dredg_ed
dwined114610213dwi_ned
eagled82914043_eagled
earned74818333_earned
edged85514513_edg_ed
egged85114383_e_gged
eloigned1043423eloigned
engined9119893_engined
ermined10410603ermined
evened101010313_evened
feign94210713feign__
feignedly1742213feignedly
feigners1235483feigners
feigns10407753feign_s
feinted11379623feinted
figged124013893_figged
fined94930503_fi_ned
finned104114603_finned
foined105915013foi_ned
foreigner1344653foreigner
freighted1755203freighted
frigged13439053frigged
fringed123611523fringed
gained84617463gai_ned
gigged104112293_gigged
ginned83813983_ginned
girned84010513_girned
grained93814273grai_ned
greened93111263gre_ened
greige847203greig_e_
greiges937733greig_es
grinned9378553grinned
groined92710813groi_ned
hedged125211793hedg_ed
heiled104415613hei_led
heired103813043hei_red
heisted113210653heisted
hinged114618913_hinged
igged86012763__igged
inned64118423__inned
jeaned143813463je_aned
jigged164412773_jigged
joined144613073joi_ned
kedged13439713kedg_ed
keened114013623ke_ened
kegged13469243ke_gged
kenned114411263ke_nned
kerned114112923ke_rned
kilned11368393_kilned
kinged124215283_kinged
kirned11408623_kirned
leagued935463leagued
leaned73422543le_aned
learned8329303learned
legend837693le_gend
legged95713083le_gged
lesioned936903lesioned
limned94811473_limned
lined64934643_li_ned
maligned1285773maligned
merged104214943merg_ed
mined85333353_mi_ned
neoned7311483ne_oned
nighed113811293_nighed
opined95113853opi_ned
pained95622853pai_ned
peened94318153pe_ened
pegged114811903pe_gged
peised94817683pei_sed
penned94217613pe_nned
pigged114214153_pigged
pined85935323_pi_ned
pinged104321383_pinged
pinned94818383_pinned
preaged11612333preag_ed
preened103214983pre_ened
preowned1435213preowned
prigged12398923prigged
raged74829453r_ag_ed
ragged94620263r_agged
raided85017703rai_ded
railed74727543rai_led
raised76120333rai_sed
ranged84824313rang_ed
rationed9410093rationed
ravened115012283ravened
ravined115411823ravined
reached134619083reached
reacted103015713reacted
readded103310733readded
readied93316623readied
reagent8716603reagent
reamed94326123re_amed
reannex1434733reannex
reaped94122453re_aped
reared75930013re_ared
reargued1035573reargued
rearmed103912823rearmed
reasoned9410733reasoned
reassigned1243593reassigned
reaved104523923re_aved
rebated103619693rebated
rebilled11318053rebilled
rebind94416923rebin_d
reblend1036653reblend
rebored105015883rebored
rebred95816353re_bred
rebreed104611073rebreed
rebuked14438343rebuked
recane83022873recane_
recanes93222263recanes
recanted112513513recanted
receded112713043receded
recited104319103recited
recked134821803re_cked
reckoned1546953reckoned
reclined113613603reclined
recoded113115033recoded
recoined113614423recoined
reconned113610653reconned
recused104714423recused
redated93120923redated
redded94019543re_dded
reddened1136423reddened
reddled102912323reddled
reded74829113re__ded
redenied10511283redenied
redesigned1343373redesigned
redialed10310793redialed
redipped1434783redipped
redlined103811233redlined
redone74820053redone_
redonned10297103redonned
redried93714893redried
reduced11610323reduced
redyed114611233re_dyed
reearned948883reearned
reed55549623re___ed
reeded84022563re_eded
reefed103816583re_efed
reeked113717643re_eked
reeled74725533re_eled
reested82916233reested
reeved104118713re_eved
refaced133713573refaced
refed93921923re__fed
refeed104717623re_feed
refenced1438993refenced
reffed134712513re_ffed
refigured1443933refigured
refiled114318653refiled
refilled12278673refilled
refilmed14235813refilmed
refind104717073refin_d
refine95225693refine_
refiner105316913refiner
refines105426343refines
refired115116993refired
refitted12309413refitted
refixed183611153refixed
refried113513873refried
refuged125410873refuged
refund104810303refun_d
refunded1336953refunded
refused115114443refused
refuted114313803refuted
regained102111243regained
regaled93615953regaled
regard85215773re_gard
regent74127673re_gent
reges65628783re_g_es
reggae858953reggae_
reggaes948883reggaes
regild8149773re_gild
regilded1135543regilded
regime95313943regime_
regimen104411573regimen
regimes104514743regimes
regina75317143regin_a
reginae84713453reginae
reginal84814293reginal
reginas85614063reginas
regive104814323regive_
regiven11478323regiven
regives115014213regives
reglet73724233re_glet
reglued936333reglued
regna64614813re_gn_a
regnal74812933re_gnal
regnum957163re_gnum
regret73723533re_gret
regrew10388563re_grew
rehanged1357833rehanged
rehinge1148503rehinge_
rehinges1248403rehinges
rehired115013153rehired
reifier103414523reifier
reifies104218283reifies
reigning1039883reigning
reignite947233reignite
reignites1046933reignites
reimaged1246173reimaged
reimagined1442893reimagined
rein46040893rei_n__
reindex1536093reindex
reink95518093rei_n_k
reinks105012153rei_nks
reins56234563rei_n_s
reinter73116843reinter
reissued944903reissued
reive85522943rei_ve_
reiver95318293rei_ver
reives95723043rei_ves
rejigger1743183rejigger
rejoined16318593rejoined
rekeyed1536163rekeyed
relaced103517213relaced
reland75920433relan_d
relanded102410463relanded
related83327573related
relaxed153312523relaxed
relayed113212753relayed
relend76116453relen_d
relented92614943relented
relied74926233re_lied
relieved12438513relieved
relighted1436863relighted
reline65434353reline_
relines75331323relines
relinked1337003relinked
relished1239433relished
relisted9312623relisted
relived115114683relived
reloaned939723reloaned
relumed1069813relumed
remained112412893remained
remand95618963reman_d
remanded123011323remanded
remanned11319353remanned
remated103522473remated
remend95216553remen_d
remended123010393remended
remiges103015473remig_es
remind94819793remin_d
reminded123411523reminded
reminted113615083reminted
remised103516843remised
remitted113312073remitted
remixed173510743remixed
removed134611313removed
renamed103114523renamed
rend56136573re__n_d
rended84524103re_nded
reneged92010763reneged
renew83917513re__new
renewed11309993renewed
rennet64624853re_nnet
renowned1235973renowned
rented74426593re_nted
reoiled84316853reoiled
reopened1138503reopened
repand95316063repan_d
repanel939963repanel
repaved133311133repaved
repegged1334883repegged
repented112614983repented
repine85627813repine_
repiner94816903repiner
repines94927383repines
repled93319773re_pled
replied103914443replied
reposed103616273reposed
repped114616723re_pped
reputed104613483reputed
rerented92516163rerented
resawed113111183resawed
rescued10410043rescued
reseed74823293re_seed
resend75016773resen_d
resented92716963resented
resewed113011823resewed
reshined123011123reshined
reshoed112212153reshoed
resided95217703resided
resifted12310153resifted
resighted1436523resighted
resign74212583resign__
resignedly1552523resignedly
resigners1036863resigners
resigns83910963resign_s
resiled84621983resiled
resisted9312693resisted
resited85122423resited
resized174614903resized
resoled84119283resoled
resowed113712253resowed
rested74430783re_sted
resumed10310623resumed
retagged1136063retagged
retained93016093retained
retaped103814283retaped
retaxed153512233retaxed
retched133814273retched
retene69224273retene_
retenes76324623retenes
retied75924983re_tied
retiled84420513retiled
retimed104714653retimed
retine66237333retine_
retines75134673retines
retinted94414363retinted
retinued95210823retinued
retired84620143retired
retitled9339553retitled
retried84419153retried
retted74826313re_tted
retune69121953retune_
retunes76918403retunes
returned9459133returned
retyped13367303retyped
reused75419563re_used
reveled113917753reveled
revenged1337553revenged
revenued1237223revenued
revered112819333revered
reviewed1534823reviewed
reviled114417923reviled
revised113815483revised
revived144211653revived
revoked154410523revoked
revoted114314153revoted
revved13469723re_vved
rewaked153811903rewaked
rewaxed18409343rewaxed
rewed95425453re__wed
reweighed1742903reweighed
rewidened1444073rewidened
rewind104715883rewin_d
rewinded13277673rewinded
rewired115413283rewired
rexine134719443rexine_
rexines144719153rexines
rezone153814783rezone_
rezones163213943rezones
ribbed114014373r_ibbed
riced85825543r_i_ced
ricked136523623r_icked
ridded93615123r_idded
ridged94014213r_idged
riffed133811563r_iffed
rifled104115003r_ifled
rifted104115313r_ifted
rigger85616713r_igger
righted122912143r_ighted
rigid7913893r_ig_id
riled65833253r_i_led
rilled74525653r_illed
rimed84826373r_i_med
rimmed114812303r_immed
rind56535603r_i_n_d
rinded84418983r_inded
ringer74526053r_inger
rinsed75016353r_insed
rioted73416373r_ioted
riped85226433r_i_ped
ripened1038203ripened
ripped114419013r_ipped
risked115514633r_isked
rived94825613r_i_ved
rogued84711473r_ogued
roiled74320053roi_led
rosined84911903rosined
rouged86717323roug_ed
roughed124210943roughed
rugged94215373r_ugged
ruiner64013643rui_ner
sained75424243sai_ned
segued838513se_gued
seigneur942933seigneur
seine55732873sei_ne_
seiner64622483sei_ner
seines65029903sei_nes
seised74218123sei_sed
seized164313653sei_zed
serged84118763serg_ed
shined104620783shi_ned
shinned114310913shinned
sieged85212713sieg_ed
sighed113712053_sighed
signee73617233_signee
signer74015623_signer
signet73621153_signet
singed85422293_singed
sinned73818413_sinned
skeined1236773skei_ned
skinned12387293skinned
skreighed1842453skreighed
sleighed1334033sleighed
soigne74310033soigne_
soignee8279133soignee
spined95423943spi_ned
swigged13327183swigged
swinged123810793swinged
teind6213613tei_n_d
tenoned839363tenoned
thighed1535263thighed
thinned11399153thinned
tined65434533_ti_ned
tinged84220793_tinged
tinned74317533_tinned
trained84117203trai_ned
trigged10359853trigged
trined74920713tri_ned
twigged13345283twigged
twined104413123twi_ned
twinged12398353twinged
twinned11366333twinned
unfeigned1453293unfeigned
unsigned1037553unsigned
vegged124910013ve_gged
veiled103714543vei_led
veiner94514753vei_ner
venged114011983veng_ed
verged114815153verg_ed
vined95626153_vi_ned
weaned103816153we_aned
wedged125110273wedg_ed
weened104013733we_ened
weigher14136343weigher
weighted1635593weighted
weiner94214133wei_ner
weirded1234513weirded
whined134715203whi_ned
whinged15409143whinged
wigged124413583_wigged
wined94434183_wi_ned
winged114620833_winged
winned104017013_winned
wringed123710193wringed
yeaned103813903ye_aned
yearned11327373yearned
yenned10409383ye_nned
zigged184110193_zigged
zinged174414623_zinged

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340275317.14018771.3
3Display Results5315310.1862854.8
 (SQL Overall)1786915317.48223882.8
 
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.