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

159 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
restrive1131092(None) 
restive10315931rest_ive
restrike1239671restrike
restriven1246231restriven
restrives12310661restrives
restrove1138961restrove
bestride1138612bestride
festive1339772fest_ive
prestrike1547492prestrike
redrive112410562re_drive
reserve101011202reser_ve
restrict10313632restrict
restrikes1339412restrikes
restring91518782restring
retrieve1175692re_trieve
strive95020962__strive
arrestive1246753arrest_ive
astride8311973_astride
bestrid1039973bestri_d
bestrides1237913bestrides
bestrode1147133bestrode
contrive13311353contrive
costive12312843cost_ive
creative132812803creat_ive
crescive1545283cres_cive
deprive1338303de_prive
derive103817043de__rive
describe1346243describe
deserve11108703deser_ve
destine83719953dest_ine
destrier9311823destrier
dextrine1688253dextrine
egestive1246833egest_ive
erective13311833erect_ive
eserine7415903_eserine
estrin6315923_estri_n
estrins7315853_estrins
estriol747553_estriol
estrone7413953_estrone
gentrice1148813gentrice
gestative1347303gestative
misdrive1446683misdrive
nestlike1236083nestlike
oestrin7312243oestri_n
oestrins8312673oestrins
oestriol845383oestriol
oestrone849973oestrone
orective1339353orect_ive
outstrive1265083outstrive
postdive1445763postdive
prescribe15106673prescribe
preserve13108803preser_ve
prestige11310733prest_ige
reactive13310473reactive
receive1239733re_ceive
rectrices1338873rectrices
rectrix1645363rectri_x
recursive1445453recursive
recurve1237403recur_ve
redriven12226153re_driven
redrives122610393re_drives
redrove11249423re_drove
regive104814323re__give
reive85522943re___ive
relative11313143relative
relive95120783re__live
reprice113212833re_price
reprieve1375443re_prieve
reprise92715043re_prise
reprove122911073re_prove
reptile93914083rept_ile
rerise64325633re__rise
rescript1277423rescript
reseize1639553res_eize
resentive12410723resentive
reserpine1147523reserpine
reserved121010583reser_ved
reserver11119633reser_ver
reserves111011983reser_ves
reservice1445273reservice
reshave1338603res_have
reshine102816943res_hine
reside74224933res__ide
resile64627673res__ile
resistive1247583resistive
resite64128453res__ite
resize154117723res__ize
resolve103910983res_olve
resorptive1544763resorptive
respire9411543res_pire
respite9513033res_pite
resplice1237253resplice
respring111614063respring
restable101618443restable
restage83316193rest_age
restate73824883rest_ate
resting85031183rest_ing
restively1548313rest_ively
restoke116113903rest_oke
restorative1446943restorative
restore75822983rest_ore
restoring10314613restoring
restrain8311703restrain
restrained1148413restrained
restrainer1046973restrainer
restrains9311623restrains
restraint9412753restraint
restress82511773restress
restricken1643793restricken
restricted1348303restricted
restrictive1646363restrictive
restricts1138823restricts
restrings10159293restrings
restriving1448133restriving
restroom1047573restroom
restruck1445223restruck
restrung9176443restrung
restyle1038763rest_yle
resupine1037543resupine
resurge839073resur_ge
resurvey1444823resur_vey
retie55735303re_t_i_e
retile65929673re_t_ile
retime85321803re_t_ime
retine66237333re_t_ine
retire64927013re_t_ire
retiree75019083re_tiree
retrace91417343re_trace
retrial7615553re_trial
retried84419153re_tried
retries74129073re_tries
retrieved1385093re_trieved
retriever1284213re_triever
retrieves1265653re_trieves
retrim83514883re_tri_m
retrims93612373re_trims
reverie103615163reveri_e
revertive1548853revertive
revive124914823re__vive
rewrite10311143re_write
rostrate8313843rostrate
scrive115414943__scrive
sestine73017923sest_ine
shrive125216953__shrive
striae65422273__striae
stride75420963__stride
strife95318363__strife
strike105619733__strike
stripe85822443__stripe
strived114713663__strived
striven103910753__striven
striver104315203__striver
strives104119373__strives
strove95014793__strove
vestige1137433vest_ige
vestlike1535393vestlike
vestries11314053vestries
wastrie101210303wastri_e
yestereve1543133yestereve

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.423422437.4
2DLD Change Limit1461621597.08020644.4
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.56323627.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.