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

448 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
restive1031593(None) 
festive1339771festive
restrive11310921restrive
arrestive1246752arrestive
costive12312842costive
creative132812802creative
crescive1545282crescive
destine83719952destine
egestive1246832egestive
erective13311832erective
orective1339352orective
prestige11310732prestige
reactive13310472reactive
receive1239732receive
redrive112410562redrive
regive104814322re_give
reive85522942re__ive
relative11313142relative
relive95120782re_live
reptile93914082reptile
reseize1639552reseize
resentive12410722resentive
reserve101011202reserve
reshave1338602reshave
reshine102816942reshine
reside74224932res_ide
resile64627672res_ile
resistive1247582resistive
resite64128452res_ite
resize154117722res_ize
resolve103910982resolve
respire9411542respire
respite9513032respite
restage83316192restage
restate73824882restate
resting85031182resting
restively1548312restively
restoke116113902restoke
restore75822982restore
restrike1239672restrike
restriven1246232restriven
restrives12310662restrives
restrove1138962restrove
restyle1038762restyle
retie55735302re_ti_e
retile65929672re_tile
retime85321802re_time
retine66237332re_tine
retire64927012re_tire
revive124914822re_vive
sestine73017922sestine
vestige1137432vestige
active11313743_active
aestival1145483aestival
aestivate12127663aestivate
agentive1248043agentive
amative12311733amative
bastile9313913bastile
beastie92412433beasti_e
bedtime1236973bedtime
beehive1554033beehive
belive115415303be_live
beshiver1634483beshiver
beside95114613bes_ide
beslime1146833beslime
besmile1137463besmile
bestial9311643bestial
besting104923923besting
bestir8311163besti_r
bestirs9311133bestirs
bestride1138613bestride
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
captive1438973captive
caressive1445823caressive
centile94217183centile
centime114513033centime
cesti75217423cesti__
cestode1037963cestode
creatine103417413creatine
creatives14279693creatives
cresting114017043cresting
cystine1239333cystine
dative10311813_dative
deceive1337813deceive
denotive1238673denotive
dentine83320243dentine
deprive1338303deprive
derive103817043de_rive
deserve11108703deserve
desire7415303des_ire
despise1038683despise
despite10410123despite
destined103312453destined
destines93619663destines
destiny113111463destiny
digestive1446243digestive
directive1557773directive
ejective2037153ejective
elative10312453elative
elective13311003elective
emotive1239193emotive
endive103310473_endive
entice81316863_entice
entire61617703_entire
erectile1039513erectile
ergative1238973ergative
erosive1039193erosive
erotize16311663erotize
eruptive1345793eruptive
estate64719763_estate
estival1036323_estival
estivate111010003_estivate
exertive1839083exertive
fertile10311733fertile
festival1444713festival
festively1845773festively
fictive1537023fictive
furtive1337173furtive
genitive1247643genitive
gentile83515293gentile
gestate83614073gestate
gestative1347303gestative
geste65920693gest__e
gestic9312773gesti_c
gesture839243gesture
hessite1038993hessite
hostile10312553hostile
ideative1238573ideative
ingestive1347393ingestive
jesting154317713jesting
jussive1734293jussive
justice1637423justice
lenitive1148493lenitive
massive12289773massive
mestee84523883mest_ee
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
misgive13339033misgive
mislive122812693mislive
missive122413143missive
mistime11312613mistime
motive113112143_motive
native9613013_native
negative1239083negative
nesting84320443nesting
nestle63013953nest_le
nestlike1236083nestlike
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
pectize20259913pectize
pensive122610393pensive
peptide122910683peptide
peptize20279483peptize
pestier94317403pestier
pestle83215843pest_le
petite84320653pe_tite
positive1349993positive
postdive1445763postdive
postie84123963posti_e
precative16312573precative
predive13511083pre_dive
prentice121012353prentice
preserve13108803preserve
preside10715613pres_ide
preslice1258623preslice
presolve1347073presolve
prestiges12310593prestiges
prestore104217353prestore
prestrike1547493prestrike
pristine10313503pristine
prostie91617743prosti_e
ragtime1036163ragtime
ratine65131823r_atine
ratite65022423r_atite
realise73021813realise
realize162717083realize
reave84528023re__ave
received1437983received
receiver1337413receiver
receives1339743receives
receptive1648323receptive
recessive1447263recessive
recipe103414893re_cipe
recite83625113re_cite
recline94020493recline
recti73619623recti__
rectify1536453rectify
recurve1237403recurve
rediae74221993re_diae
redline84218833redline
redriven12226153redriven
redrives122610393redrives
redrove11249423redrove
reductive1547793reductive
reesting93118273reesting
reeve84121323re__eve
refective1749113refective
refile95122373re_file
refine95225693re_fine
refire95419473re_fire
regave104713383re_gave
regime95313943re_gime
regiven11478323re_given
regives115014213re_gives
rehire95415863re_hire
reived104518133re__ived
reiver95318293re__iver
reives95723043re__ives
rejective2148253rejective
rejoice16287453rejoice
relatives1239963relatives
releve95116403re_leve
relieve105010693relieve
reline65434353re_line
relived115114683re_lived
relives104619443re_lives
remise84221953re_mise
remissive1445773remissive
remove116115573re_move
rente54733783rent__e
rentier73618223rentier
renting84026853renting
repave114813873re_pave
repine85627813re_pine
reprice113212833reprice
reprieve1375443reprieve
reprise92715043reprise
reprove122911073reprove
reptiles103913063reptiles
require16148653require
requite162012483requite
reraise7316313reraise
rerise64325633re_rise
resaid74517083resai_d
resail64418733resai_l
resailed93613063resailed
resails74616743resails
resale64025543res_ale
rescale93215473rescale
rescind10410393rescind
rescore95616203rescore
rescue8313003res_cue
resee54336333res__ee
reseized1839213reseized
reseizes1759853reseizes
reserved121010583reserved
reserver11119633reserver
reserves111011983reserves
resettle837303resettle
reshape1249043reshape
reshaved1536873reshaved
reshaven1435193reshaven
reshaves1438733reshaves
reshined123011123reshined
reshines112615443reshines
reship11310673reshi_p
reships1239863reships
reshoe92816483res_hoe
reshone102414163reshone
resid64124093res_i_d
resided95217703res_ided
resider84615803res_ider
resides84523283res_ides
resids74219153res_ids
residue8689863residue
resift94017723res_ift
resign74212583res_ign
resiled84621983res_iled
resiles74026543res_iles
resilver11337503resilver
resin54131053res_i_n
resined84522653res_ined
resins64528773res_ins
resiny94617363res_iny
resist64524533res_ist
resit54241043res_i_t
resited85122423resited
resites74027793resites
resiting93521123resiting
resits64725563res_its
resized174614903res_ized
resizes164216843res_izes
reslate73520593reslate
resole64624183res_ole
resolved12349343resolved
resolver11339793resolver
resolves113010783resolves
resorptive1544763resorptive
respace11310913respace
respade1039573respade
respective1747623respective
respired1148993respired
respires10311903respires
respited11410813respited
respites10513243respites
resplice1237253resplice
respoke134311283respoke
rest46459843rest___
restable101618443restable
restack1339433restack
restaff1339013restaff
restaged103011863restaged
restages92815773restages
restamp1146483restamp
restart7320033restart
restated93120183restated
restates83423433restates
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restful1038623restful
restitch1344693restitch
restitute947753restitute
restock1338673restock
restoked135710533restoked
restokes125213043restokes
restored96417193restored
restorer84813723restorer
restores85222993restores
restrict10313633restrict
restrikes1339413restrikes
restring91518783restring
rests54935873rest__s
restudy1144763restudy
restuff1346953restuff
restyled1236943restyled
restyles1139193restyles
resume8313783res_ume
resupine1037543resupine
resurge839073resurge
resurvey1444823resurvey
retake104718533re_take
retape83917683re_tape
rete44944133re_t__e
retene69224273re_tene
retentive1249853retentive
retia55326113re_ti_a
retial64724993re_tial
reticle94112623re_ticle
retied75924983re_tied
reties65436193re_ties
retiled84420513re_tiled
retiles74426993re_tiles
retimed104714653re_timed
retimes95020173re_times
retina65023383re_tina
retinae75517333re_tinae
retines75134673re_tines
retint65633443re_tint
retinue75414843re_tinue
retired84620143re_tired
retiree75019083re_tiree
retirer74715013re_tirer
retires74726213re_tires
retitle73913093re_title
retore67630773re_tore
retrieve1175693retrieve
retsina74710603retsina
retting83425883retting
retune69121953re_tune
retuse66617223re_tuse
retype11399143re_type
reunite7312713reunite
revertive1548853revertive
revile94921613re_vile
revise94019743re_vise
revived144211653re_vived
reviver134411373re_viver
revives134715543re_vives
revoice12319183revoice
revolve13328373revolve
reweave1336773reweave
rewire95421413re_wire
rewove126420083re_wove
rewrite10311143rewrite
rexine134719443re_xine
riptide1036883riptide
rive75537723r___ive
rotative11310343rotative
routine72615903routine
rusine63916593rus_ine
rustic8712673rusti_c
rustics9810733rustics
rustier74416363rustier
rustily103112993rustily
rusting83821263rusting
rustle63615413rust_le
rutile65217683r_utile
sectile9311973sectile
sedative1238853sedative
sensitive1246963sensitive
septime1138803septime
sessile739523sessile
sestina72711973sestina
sestines82717243sestines
sextile1438573sextile
shive114423423__shive
skive124614113__skive
stative102612933stative
stave85324993__stave
stile54931573__stile
stime76521803__stime
stipe76523373__stipe
stiver93915733__stiver
stove85220253__stove
strive95020963__strive
swive115316193__swive
teatime9310083teatime
tectite9310583tectite
tektite1136883tektite
tensive10269913tensive
tentie62521183tenti_e
testae64216253test_ae
testate73916233testate
testee64323303test_ee
testicle1037443testicle
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713testi_s
textile1437223textile
tractive13310043tractive
treatise8311103treatise
trestle72611363trest_le
tussive1035303tussive
unitive10310563unitive
vegetive1545543vegetive
vespine1237903vespine
vestee94319153vest_ee
vestiges1238243vestiges
vesting114618683vesting
vestlike1535393vestlike
vesture10310373vesture
vetiver1336103ve_tiver
visive1257873vis_ive
votive12348933_votive
westing115020273westing
wresting123811833wresting
wrestle10298843wrest_le
yeshiva1642403yeshiva
zestier163010223zestier
zestily19167563zestily
zesting174515333zesting

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.406440125.6
2DLD Change Limit1340274487.08018930.4
3Display Results4484480.1702635.3
 (SQL Overall)1786914487.65623340.0
 
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.