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

515 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
restates8342343(None) 
estates74520181_estates
gestates93213731gestates
reslates83619501reslates
restages92815771restages
restate73824881restate_
restated93120181restated
testates83615451testates
estate64719762_estate_
estated83715572_estated
gestate83614072gestate_
gestated102910572gestated
hesitates1269792hesitates
instates81615832instates
metates92720012me_tates
pectates122213952pectates
prostates11314422prostates
rebates95123182re_bates
recrates102420372recrates
redates83423872re_dates
reflates113115662reflates
regrates92618402regrates
reinstates1048292reinstates
relates73731432re_lates
remates93827112re_mates
replates102919272replates
resales74724902res_ales
rescales103414572rescales
reseated93220262reseated
reseats74319582reseat_s
reshapes1338802reshapes
reshaves1438732reshaves
resinates9314762resinates
resites74027792res_ites
resituates1047752resituates
reslate73520592reslate_
reslated93517522reslated
resonates9412402resonates
respaces12311042respaces
respades1139852respades
respites10513242respites
restables111511422restables
restacks1438092restacks
restaffs1444782restaffs
restage83316192restage_
restaged103011862restaged
restamps1234702restamps
restarted10410052restarted
restarts8310872restarts
restokes125213042restokes
restores85222992restores
restyles1139192restyles
retakes113718862re_takes
retapes93917422re_tapes
retastes82212902re_tastes
retaxes143615092re_taxes
rotates72819772r_otates
states64337082__states
testate73916232testate_
unstates81314992unstates
upstates10189642upstates
acetates102013063acetates
aerates74627493ae_rates
aesthetes1246233aesthetes
aestivates13107363aestivates
agitates9310883agitates
apostates1149163apostates
aristate8312133aristate_
arsenates979373arsenates
bedmates1349183bedmates
berates94126873be_rates
beshames1537203beshames
betakes134212523be_takes
bistate9313823bistate_
caseates10313713caseates
castrates11312673castrates
centares102913893centares
cerates95428253ce_rates
cestas85018543cesta__s
cestodes1138203cestodes
cestuses1038083cestuses
cetanes9315133ce_tanes
costate94019273costate_
creates95225203cre__ates
cremates124216003cre_mates
crepitates1485903crepitates
crewmates16375803crewmates
cristate10310603cristate_
cristated1247423cristated
dealates92716683dealates
debates103718533de_bates
deflates123013943deflates
delates83526283de_lates
dentate8315153dentate_
dentated10411703dentated
derates84028893de_rates
desolates10311793desolates
despites11410313despites
destains9311813destains
destines93619663destines
devastates1444663devastates
deviates12312733deviates
dictates11311383dictates
disrates91118153disrates
distastes1039633distastes
distaves12311403distaves
dressages1144153dressages
ectases92911673_ectases
edentates1046953edentates
elates65032363_e_lates
eluates72014683_eluates
enates64026423_e_nates
entases72816273_entases
equates162012323_equates
ergates8314493_ergates
ersatzes1743073ersatzes
eructates1146953eructates
escapes113811673_escapes
esthetes1147743_esthetes
estimates11911363_estimates
estivates12109753_estivates
etapes85415293_e_tapes
fellates11312753fellates
ferrates113013423ferrates
festinates1348943festinates
forestages1446733forestages
frustrates1345003frustrates
gelates83219583ge_lates
gemmates13307673gemmates
geotaxes1644743geotaxes
gestalten1042703gestalten
gestalts955493gestalts
gestapos1153913gestapos
gestes75721393ges__tes
gestures9310013gestures
hastate10313913hastate_
hebetates1446433hebetates
hectares1338853hectares
hektares1535813hektares
heptanes1339003heptanes
hesitate1169973hesitate_
hesitated1377783hesitated
hesitater1276923hesitater
hesitaters1374853hesitaters
hessites1138613hessites
hostages122311693hostages
imitates10310503imitates
instate71616483instate_
instated91613343instated
intestates10159433intestates
irritates977223irritates
lactates10311223lactates
legates82917683le_gates
levitates1247863levitates
lustrates939463lustrates
lysates10317473lys_ates
mediates112814063mediates
meditates1239813meditates
meltages1148243meltages
mesdames1346043mesdames
messages1138233messages
messmates1346233messmates
mestees94617753mest_ees
metages102714973me_tages
metate82720533me_tate_
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
misstates11710633misstates
mistakes141213413mistakes
mutates92215793_mutates
negates83215843ne_gates
neonates8310063neonates
nestles73015463nest_les
nictates1039593nictates
notates72817483_notates
nutates73214973_nutates
orientates1046043orientates
outstates91710753outstates
overstates131110113overstates
pectases122411193pectases
pectate112214693pectate_
peltate92013773peltate_
penates93321593pe_nates
pentanes10316083pentanes
pesades10310903pes_ades
pestles93217693pest_les
petites93820203pe_tites
postages112815323postages
postdates1248863postdates
predates11615813pre_dates
prelates10418573pre_lates
presages11312203pres_ages
presales10315263pres_ales
preshapes1667093preshapes
prestamps1543523prestamps
prestiges12310593prestiges
prestores114716083prestores
pretapes122811533pre_tapes
pretastes11119423pre_tastes
pristanes11410433pristanes
prostate10314533prostate_
prostrates12411993prostrates
radiates92415293radiates
rates55352013r___ates
ratites74920683r_atites
reales64934123re__ales
reatas64021013re__atas
reaves94127573re__aves
reawakes15348073reawakes
rebate84424113re_bate_
rebated103619703re_bated
rebater93517913re_bater
rebaters103413943re_baters
rebatos92913113re_batos
recanes93222263re_canes
recites93524583re_cites
reclames12310893reclames
recoated113416783recoated
recoats92616643recoat_s
recrate92621663recrate_
recrated112918603recrated
recreates11313363recreates
rectorates12410363rectorates
redate74124683re_date_
redated93120923re_dated
redictates1348233redictates
redstarts1044243redstarts
redtails968003redtails
redwares1239053redwares
reestimates1346353reestimates
refaces123216743re_faces
reflate103516263reflate_
reflated123514293reflated
reframes1338993reframes
refutes104515723re_futes
regales83520793re_gales
regattas944473regattas
regelates10311113regelates
reggaes948883regga_es
reglazes1846793reglazes
regrades103212173regrades
regrate82618663regrate_
regrated102816333regrated
regulates101211723regulates
reheated122415003reheated
reheater113413033reheater
reheaters122010273reheaters
reheats104513523reheat_s
reimages1138373reimages
reinstate948893reinstate_
reinstated1147283reinstated
reiterates10412003reiterates
relaces93420883re_laces
relate64033633re_late_
related83327573re_lated
relater73723143re_later
relaters83218153re_laters
relaxes143215323re_laxes
releases8313343releases
relegates10310943relegates
relocates11712933relocates
reluctates1246703reluctates
remakes134116173re_makes
remate84428683re_mate_
remated103522473re_mated
remotes94521613re_motes
renames92418053re_names
rennases848983rennases
renovates1248453renovates
rentals74017473renta_ls
rentes65431193re__ntes
repaves123513653re_paves
repeated113117443repeated
repeater102615443repeater
repeaters112811993repeaters
repeats94316053repeat_s
replaces123114123replaces
replate93420053replate_
replated112817513replated
repletes102812463repletes
reptiles103913063reptiles
reputes94615963re_putes
requites171511763requites
reroutes8312223reroutes
resails74616743res_ails
resale64025543res_ale_
resalutes947433resalutes
resat55139683res_at__
resawed113111183res_awed
resaws93713513res_a_ws
resays93714153res_a_ys
rescale93215473rescale_
rescaled113311303rescaled
rescores105415693rescores
rescues9312753res_cues
resealed92713963resealed
reseals73917663resea_ls
reseat64131493reseat__
reseaus74012153resea_us
resected112514743resected
resects94115593resect_s
resees63827483res__ees
reseizes1759853reseizes
resented92716963resented
resents74221223resent_s
reserves111011983reserves
resets65427613res_et_s
resetter81511833resetter
resetters9129463resetters
resettles936563resettles
reshape1249043reshape_
reshaped1437203reshaped
reshaper1336913reshaper
reshapers1435493reshapers
reshave1338603reshave_
reshaved1536873reshaved
reshaven1435193reshaven
reshes94124363res__hes
reshines112615443reshines
reshoes102316033res_hoes
resides84523283res_ides
residues9338813residues
resifted12310153resifted
resifts10378703resift_s
resiles74026543res_iles
resinate8316773resinate_
resinated10413283resinated
resisted9312693resisted
resister8311653resister
resisters9310453resisters
resists74414923resist_s
resite64128453res_ite_
resited85122423res_ited
resits64725563res_it_s
resituate948613resituate_
resituated1147323resituated
resizes164216843res_izes
resoaked1337943resoaked
resoaks1148973resoa_ks
resoften1145443resoften
resoftens1243713resoftens
resojets1535343resojets
resoles73823653res_oles
resolutes968193resolutes
resolves113010783resolves
resonate8513513resonate_
resonated10510613resonated
resorted9313493resorted
resorter8312183resorter
resorters939693resorters
resorts74817193resort_s
respace11310913respace_
respaced1338503respaced
respade1039573respade_
respaded1238133respaded
respires10311903respires
respite9513033respite_
respited11410813respited
respots92912763respot_s
restable101618443restable
restabled12148953restabled
restack1339433resta_ck
restacked1636483restacked
restaff1339013resta_ff
restaffed1653753restaffed
restamp1146483resta_mp
restamped1444433restamped
restart7320033resta_rt
restating102319413restating
restation9316913restation
restations10315843restations
rested74430783res__ted
rester63832433res__ter
resters74130403rest_ers
restitch1344693restitch
restitches1545063restitches
restitutes1057833restitutes
restive10315933restive_
restless82713163restless
restocks1437503restocks
restoke116113903restoke_
restoked135710533restoked
restore75822973restore_
restored96417193restored
restorer84813723restorer
restorers95110113restorers
restrains9311623restrains
restress82511773restress
restrikes1339413restrikes
restrives12310663restrives
rests54935873res__t_s
restudies10156033restudies
restuffs1444193restuffs
restyle1038763restyle_
restyled1236943restyled
resulted939713resulted
results739833result_s
resumes9313373res_umes
resurges9310123resurges
retables101712673re_tables
retacks132210713re_tacks
retags73414303re_ta_gs
retails74718973re_tails
retains74522253re_tains
retake104718533re_take_
retaken113911803re_taken
retaker113714313re_taker
retakers123511133re_takers
retape83917683re_tape_
retaped103814283re_taped
retards85015003re_tards
retaste72313133re_taste_
retasted92412113re_tasted
retaxed153512233re_taxed
retches123318513re_tches
retenes76324623re_tenes
reties65436193re_t_ies
retiles74426993re_tiles
retimes95020173re_times
retines75134673re_tines
retires74726213re_tires
retitles83612593re_titles
retraces101417273retraces
retries74129073re_tries
retted74826313re_t_ted
retunes76918403re_tunes
retypes12308623re_types
reunites8312473reunites
reuptakes1543213reuptakes
reutter71010093reut_ter
reutters8138573reut_ters
revotes104716393re_votes
rewakes144614983re_wakes
rewaxes173911333re_waxes
reweaves1436603reweaves
rewrites11311063rewrites
rheostats1243613rheostat_s
rheotaxes1943573rheotaxes
rootages939103rootages
roseate7613453roseate_
rosettes8310343rosettes
rostrate8313843rostrate_
rotate63320343r_otate_
rotated82715293r_otated
rottes64524833r_ot_tes
ruinates8311883ruinates
rusticates1248053rusticates
rustles73416413rust_les
sates54949323__s_ates
seatmates1157823seatmates
sedates83418033se_dates
senates73322583se_nates
sensates8511133sensates
septages1168263septages
septate9511873septate_
seriates82620673seriates
serrates82617023serrates
sesames9310743ses_ames
sestets7911473sestet_s
sestines82717243sestines
skates104219403__skates
slates64934063__slates
spates85028173__spates
spectates13228813spectates
stactes91914633__stactes
stades74626243__stades
stages75629493__stages
stakes103927293__stakes
stales65538293__stales
stanes64933403__stanes
stapes85028733__stapes
stares66038753__stares
stases64225563__stases
state56237333__state_
stated75427833__stated
stater64427563__stater
staters73922343__staters
stats55933363__stat_s
statues74614903__statues
status65515213__status
staves94525193__staves
substates111410333substates
tates55444983___tates
tectites1039993tectites
tektites1236613tektites
tentages91011043tentages
testacies1148373testacies
testae64216253testa_e_
testator847373testator
testators947333testators
testees74215913test_ees
testes65125823tes__tes
tractates1159763tractates
trestles83012553trest_les
tristate8311033tristate_
unstate71916213unstate_
unstated91615813unstated
upstages11147373upstages
upstares10178583upstares
upstate91610493upstate_
upstater10156663upstater
upstaters11174803upstaters
vegetates1346403vegetates
ventages12119773ventages
veritates12310973veritates
vesicates14119033vesicates
vestals104612333vesta_ls
vestas95916683vesta__s
vestees103513173vest_ees
vestiges1238243vestiges
vestries11314053vestries
vestures11311043vestures
wastages12109753wastages
wrestles113310063wrest_les

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.1561145455.1
2DLD Change Limit1461625157.26320124.2
3Display Results5155150.2202340.9
 (SQL Overall)1786915157.63923391.9
 
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.