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

502 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
restated9312018(None) 
estated83715571_estated
gestated102910571gestated
reseated93220261reseated
reslated93517521reslated
restaged103011861restaged
restarted10410051restarted
restate73824881restate_
restates83423431restates
cristated1247422cristated
dentated10411702dentated
estate64719762_estate_
estates74520182_estates
gestate83614072gestate_
gestates93213732gestates
hesitated1377782hesitated
instated91613342instated
rebated103619702re_bated
recoated113416782recoated
recrated112918602recrated
redated93120922re_dated
reflated123514292reflated
regrated102816332regrated
reheated122415002reheated
reinstated1147282reinstated
related83327572re_lated
remated103522472re_mated
repeated113117442repeated
replated112817522replated
resawed113111182res_awed
rescaled113311302rescaled
resealed92713972resealed
resected112514742resected
resented92716962resented
reshaped1437202reshaped
reshaved1536872reshaved
resifted12310152resifted
resinated10413282resinated
resisted9312692resisted
resited85122422res_ited
resituated1147322resituated
reslate73520592reslate_
reslates83619502reslates
resoaked1337942resoaked
resonated10510612resonated
resorted9313492resorted
respaced1338502respaced
respaded1238132respaded
respited11410812respited
restabled12148962restabled
restacked1636482restacked
restaffed1653752restaffed
restage83316192restage_
restages92815772restages
restamped1444432restamped
rested74430782res__ted
restoked135710532restoked
restored96417192restored
restyled1236952restyled
resulted939712resulted
retaped103814282re_taped
retasted92412112re_tasted
retaxed153512232re_taxed
retted74826312re_t_ted
rotated82715292r_otated
stated75427832__stated
testate73916232testate_
testates83615452testates
unstated91615812unstated
acetated112010683acetated
aerated85322373ae_rated
aestivated14106293aestivated
agitated1038413agitated
ansated84214003ans_ated
areolated1089713areolated
aristate8312133aristate_
belated103520013be_lated
berated104422133be_rated
beshamed1635733beshamed
beslaved1435023beslaved
besotted1135843besotted
besteaded1345073besteaded
bested94922763bes__ted
bestowed14156623bestowed
betaxed17307023be_taxed
betted94721163be_t_ted
bistate9313823bistate_
caseated11310713caseated
castrated1239513castrated
cerated103922473ce_rated
costate94019273costate_
created104323453cre__ated
cremated133412963cre_mated
crenated113013913cre_nated
crepitated1584743crepitated
crested103416533cres__ted
crispated1445023crispated
cristate10310603cristate_
cuspated1335913cuspated
dealated103213603dealated
debated113916083de_bated
defatted1335673defatted
defeated132812163defeated
deflated133412303deflated
delated93722873de_lated
dentate8315153dentate_
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
descanted1336673descanted
deserted101012203deserted
desisted1039783desisted
desolated1139653desolated
despited1248323despited
destained1158253destained
destined103312453destined
devastated1544123devastated
deviated13311043deviated
dictated1239203dictated
disrated10915573disrated
distasted1137963distasted
elated74725823_e_lated
equated171910403_equated
eructated1245643eructated
escaped12388853_escaped
escoted1038183_escoted
essayed1134013_essayed
estimated12109443_estimated
estivated13108323_estivated
estrayed1236393_estrayed
estreated1039563_estreated
fellated1239563fellated
festered122512113festered
festinated1447533festinated
fetted104817893fe_t_ted
fretted113411853fre_t_ted
frustrated1444103frustrated
gelated93615633ge_lated
gemmated14336293gemmated
gestalten1042713gestalten
gestured1036993gestured
guttated10266873guttated
hastate10313913hastate_
heated104525593he__ated
hebetated1544663hebetated
hesitate1169973hesitate_
hesitater1276923hesitater
hesitates1269793hesitates
imitated1138263imitated
instate71616483instate_
instates81615833instates
irritated1076133irritated
jested144416503jes__ted
jetted143915083je_t_ted
lactated1138863lactated
legated92513983le_gated
letted74118543le_t_ted
levitated1346413levitated
lustrated1037963lustrated
meated94222403me__ated
mediated123011873mediated
meditated1348083meditated
messaged1235543messaged
metaled102913883me_taled
metate82720533me_tate_
metates92720013me_tates
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
misstated1278973misstated
mutated102712253_mutated
negated93413233ne_gated
nested74720063nes__ted
nestled8349913nest_led
netted74118713ne_t_ted
nictated1137793nictated
notated82713663_notated
nutated83113423_nutated
orientated1144853orientated
outstated10169813outstated
overstated14119443overstated
pectate112214693pectate_
pectates122213953pectates
peltate92013773peltate_
pennated11299543pennated
pestered112814973pestered
pestled102711453pest_led
petaled103614153pe_taled
petted94121523pe_t_ted
postdated1346883postdated
predated12513273pre_dated
preheated1539813preheated
presaged1238803pres_aged
presented12311633presented
preshaped1745523preshaped
presifted1536873presifted
presoaked1635653presoaked
presorted1239453presorted
prestamped1742963prestamped
prestored125111673prestored
pretaped13339133pre_taped
pretasted12147963pre_tasted
prostate10314533prostate_
prostates11314423prostates
prostrated1349423prostrated
radiated102512593radiated
rated65441383r___ated
ratted74923343r_at_ted
reacted103015713re_acted
readapted1344803readapted
reamed94326123re__amed
reaped94122453re__aped
reared75930013re__ared
reaved104523923re__aved
reawaked16366623reawaked
rebaited11410543rebaited
rebate84424113re_bate_
rebater93517913re_bater
rebates95123183re_bates
rebooted11248463rebooted
rebutted11126783rebutted
recaned102817203re_caned
recanted112513513recanted
recharted1557563recharted
recited104319103re_cited
recoaled113111783recoaled
recrate92621663recrate_
recrates102420373recrates
recreated12412533recreated
redacted12410243redacted
redate74124683re_date_
redates83423873re_dates
redbaited1344713redbaited
redialed10310793redialed
redictated1447483redictated
redrafted1435143redrafted
reedited10310083reedited
reenacted1236853reenacted
reested82916233re_ested
reestimated1445953reestimated
refaced133713573re_faced
refected142311663refected
refitted12309413refitted
reflate103516263reflate_
reflates113115663reflates
refloated1347013refloated
refracted1557393refracted
reframed1437853reframed
refuted114313803re_futed
regaled93615963re_galed
regeared1039433regeared
regelated1139723regelated
reglazed1935743reglazed
regraded113410763regraded
regrafted1435243regrafted
regranted1137703regranted
regrate82618663regrate_
regrates92618403regrates
regulated11310463regulated
reheater113413033reheater
reimaged1246173reimaged
reinstate948903reinstate_
reinstates1048293reinstates
reiterated11410153reiterated
rejected182710113rejected
relaced103517213re_laced
relate64033633re_late_
relater73723143re_later
relates73731433re_lates
relaxed153312533re_laxed
relayed113212753re_layed
released9310243released
relegated1139763relegated
relented92614943relented
relisted9312623relisted
reloaded1059103reloaded
reloaned939723reloaned
relocated12710813relocated
reluctated1345943reluctated
relucted1138653relucted
remate84428683re_mate_
remates93827113re_mates
remelted11310153remelted
reminted113615083reminted
remitted113312073remitted
renamed103114523re_named
renested92212953renested
renovated1347173renovated
rented74426593re__nted
repasted112611533repasted
repaved133311133re_paved
repealed113211873repealed
repeater102615443repeater
repented112614983repented
replaced133211403replaced
replanted1248063replanted
replate93420053replate_
replates102919273replates
replayed14248633replayed
reported11312703reported
repotted1139283repotted
reputed104613483re_puted
requited18169723requited
rerented92516163rerented
rerouted9311143rerouted
resaid74517083res_a_id
resailed93613063resailed
resale64025543res_ale_
resales74724903res_ales
resaluted1046473resaluted
resat55139683res_at__
rescale93215473rescale_
rescales103414573rescales
rescored114513103rescored
rescued10410043res_cued
reseat64131493reseat__
reseats74319583reseat_s
reseed74823293res__eed
reseeded1038093reseeded
reseized1839213reseized
reserved121010583reserved
resetter81511833resetter
resettled1035303resettled
resewed113011823res_ewed
reshape1249043reshape_
reshaper1336913reshaper
reshapes1338803reshapes
reshave1338603reshave_
reshaven1435193reshaven
reshaves1438733reshaves
reshined123011123reshined
reshoed112212153res_hoed
reshowed15117063reshowed
resided95217703res_ided
resighted1436523resighted
resigned1038863resigned
resiled84621983res_iled
resinate8316773resinate_
resinates9314763resinates
resined84522653res_ined
resister8311653resister
resite64128453res_ite_
resites74027793res_ites
resituate948613resituate_
resituates1047753resituates
resized174614903res_ized
resmelted1236043resmelted
resodded1136353resodded
resoften1145443resoften
resoled84119283res_oled
resolved12349343resolved
resonate8513513resonate_
resonates9412403resonates
resorbed1138533resorbed
resorter8312183resorter
resowed113712253res_owed
respace11310913respace_
respaces12311043respaces
respade1039573respade_
respades1139853respades
respected1438493respected
respired1148993respired
respite9513033respite_
respites10513243respites
respotted1235953respotted
resprayed1544353resprayed
restable101618443restable
restables111511423restables
restack1339433resta_ck
restacks1438093restacks
restaff1339013resta_ff
restaffs1444783restaffs
restamp1146483resta_mp
restamps1234703restamps
restart7320033resta_rt
restarts8310873restarts
restating102319413restating
restation9316913restation
restationed1244373restationed
rester63832433res__ter
restitch1344693restitch
restitched1644133restitched
restituted1156533restituted
restive10315933restive_
restocked1655173restocked
restoke116113903restoke_
restokes125213043restokes
restore75822983restore_
restorer84813723restorer
restores85222993restores
restrained1148413restrained
restricted1348303restricted
restudied11104853restudied
restuffed1663333restuffed
restyle1038763restyle_
restyles1139193restyles
resumed10310623res_umed
resurged1038623resurged
retacked15169273re_tacked
retagged1136063re_tagged
retailed94113963re_tailed
retained93016093re_tained
retake104718533re_take_
retaken113911803re_taken
retaker113714313re_taker
retakes113718863re_takes
retape83917683re_tape_
retapes93917423re_tapes
retard75018933re_ta_rd
retarded102410753re_tarded
retaste72313133re_taste_
retastes82212903re_tastes
retaxes143615093re_taxes
retched133814273re_tched
reteamed1138013reteamed
retested92212533retested
retied75924983re_t_ied
retiled84420513re_tiled
retimed104714653re_timed
retinted94414363retinted
retired84620143re_tired
retitled9339553re_titled
retorted9312333retorted
retotaled1045953retotaled
retraced111413023retraced
retracted12410953retracted
retreated10312623retreated
retried84419153re_tried
retuned86613973re_tuned
retyped13367303re_typed
reunited939713reunited
reutter71010093reut_ter
revealed123211213revealed
reverted122714713reverted
revested122612243revested
revetted122210943revetted
revolted12319863revolted
revoted114314153re_voted
rewaked153811903re_waked
rewaxed18409343re_waxed
reweaved1535953reweaved
rewetted12228353rewetted
roseate7613453roseate_
rostrate8313843rostrate_
rotate63320343r_otate_
rotates72819773r_otates
rotted74524433r_ot_ted
ruinated939523ruinated
rusted75020923rus__ted
rusticated1346993rusticated
rustled83311323rust_led
rutted74518403r_ut_ted
sated66238533__s_ated
seated75131063__seated
sedated93714353se_dated
sensated938193sensated
septate9511873septate_
seriated92717023seriated
serrated92513433serrated
skated114414883__skated
slated75028313__slated
spectated14236593spectated
staged84521563__staged
staked114621943__staked
staled74728103__staled
staned74824643__staned
stared75429873__stared
started84217323__started
state56237333__state_
stater64427563__stater
states64337083__states
statued8459893__statued
staved103918053__staved
stayed104817273__stayed
teated74924023te__ated
testae64216253testa_e_
testator847373testator
tested74421523tes__ted
treated83618703tre__ated
tristate8311033tristate_
unsated83419933uns_ated
unseated91317683unseated
unstate71916213unstate_
unstates81314993unstates
unstayed12168393unstayed
upstaged12135243upstaged
upstared11156573upstared
upstarted1244213upstarted
upstate91610493upstate_
upstater10156663upstater
upstates10189643upstates
vegetated1445083vegetated
vesicated15117653vesicated
vested104217353ves__ted
vestured1237463vestured
vetted104316323ve_t_ted
vistaed1138023vista_ed
westered122511873westered
wetted103717023we_t_ted
wrested113410933wres__ted
wrestled12296763wrest_led
zested164214043zes__ted

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.423422437.4
2DLD Change Limit1461625027.79618748.3
3Display Results5025020.2162324.1
 (SQL Overall)1786915028.43521184.5
 
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.