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

253 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
resinate831677(None) 
resinated10413281resinated
resinates9314761resinates
resonate8513511resonate
designate1147112designate
festinate1249472festinate
geminate11411792geminate
hesitate1169972hesitate
pepsinate1346632pepsinate
reclinate11410022reclinate
reginae84713452regina_e
resite64128452resi__te
resituate948612resituate
reslate73520592res_late
resonated10510612resonated
resonates9412402resonates
restate73824872res_tate
resupinate1244422resupinate
retinae75517332retina_e
retinite8314852retinite
ruinate7312832r_uinate
ruminate10511472ruminate
vesicate131210052vesicate
aestivate12127663aestivate
agminate1139243agminate
alginate9310693alginate
arsenate81010483arsenate
binate8419773__binate
brominate1348853brominate
carinate103320243carinate
caseinate1148243caseinate
celibate1259313celibate
crenate93317113cre__nate
crepitate1385953crepitate
criminate1348983criminate
deaminate12410173deaminate
decimate13411123decimate
dedicate12312803dedicate
definite1239323definite
delicate11315493delicate
delineate1047793delineate
depilate11311703depilate
derivate12311203derivate
desalinate1146673desalinate
desiccate1445923desiccate
designated1345933designated
designates1246363designates
desolate9411993desolate
detonate9311193detonate
deviate11312713devi_ate
dominate11312853dominate
echinate1359403echinate
emanate9312473_emanate
emirate91015833_emirate
enate54428143_e__nate
epilate9314283_epilate
estate64719763_es_tate
estimate10912003_estimate
estivate111010003_estivate
fascinate1447763fascinate
festinated1447533festinated
festinates1348933festinates
geminated1338543geminated
geminates12310033geminates
germinate1248623germinate
gestate83614073ges_tate
herniate1148113herniate
hesitated1377783hesitated
hesitater1276923hesitater
hesitates1269793hesitates
insinuate945963insinuate
iodinate949343iodinate
laminate103014633laminate
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
marinate103017783marinate
mediate103415213medi_ate
medicate13513243medicate
meditate11310623meditate
melinite10411743melinite
messmate1246393messmate
neonate7311333ne_onate
nominate10312473nominate
obstinate1146333obstinate
ordinate9310253ordinate
originate1047023originate
paginate114012443paginate
patinate103016313patinate
pectinate1349553pectinate
pennate93314033pe_nnate
pepsinated1545233pepsinated
pepsinates1446373pepsinates
personate112111423personate
predicate14411773predicate
quinate16511573_quinate
rabbinate1345143rabbinate
radiate83416313radi_ate
radicate11412873radicate
raffinate1545023raffinate
reanimate1148083reanimate
rebate84424103re__bate
recite83625113reci__te
recoinage1245643recoinage
recrate92621643re_crate
recreate10313603recreate
redate74124683re__date
rediae74221993redi_a_e
redictate1249063redictate
redingote1143463redingote
reestimate1246513reestimate
refinable1438623refinable
refinance14117643refinance
refine95225693refin__e
reflate103516263re_flate
regelate9312083regelate
regina75317143regina__
reginal84814293regina_l
reginas85614063regina_s
regrate82618653re_grate
regulate9313023regulate
rehinge1148503rehin_ge
reignite947233reignite
reimage1037913re_image
reincite1089703re_incite
reinflate12157403re_inflate
reinstate948883re_instate
reinter73116843re_in_ter
reinvade1244503re_invade
reinvite1177753re_invite
rekindle1344643rekindle
relate64033633re__late
relegate9311243relegate
reliance10310473reliance
reliant7319243reliant_
reline65434353relin__e
relocate10713533relocate
remate84428683re__mate
remigrate1249223remigrate
remint85329973remin_t_
reminted113615083remin_ted
remints95117293remin_ts
rename82718813re__name
rennase738713re_nnase
renominate12178423renominate
renovate1138553renovate
rente54733783re__n_te
repine85627813repin__e
replate93420053re_plate
replicate13410043replicate
resale64025543res__ale
resalute857413resalute
resat55139683res__at_
rescale93215473res_cale
reseat64131493res_eat_
reseated93220263res_eated
reseats74319583res_eats
resent63833623resen_t_
resented92716963resen_ted
resents74221223resen_ts
reshape1249043res_hape
reshave1338603res_have
reshine102816943reshin__e
reshingle1344803reshingle
reside74224933resi__de
residue8689863resi_due
resift94017723resi_ft_
resifted12310153resi_fted
resifts10378703resi_fts
resight11510643resight_
resighted1436523resighted
resights1246733resights
resile64627673resi__le
resin54131053resin___
resinating11313733resinating
resined84522653resin_ed
resinify1445053resinify
resining92919553resining
resinlike1344363resinlike
resinoid946413resinoid
resinous838503resinous
resins64528773resin__s
resiny94617363resin__y
resist64524533resi_st_
resisted9312693resi_sted
resister8311653resi_ster
resists74414923resi_sts
resit54241043resi__t_
resited85122423resi__ted
resites74027793resi__tes
resits64725563resi__ts
resituated1147323resituated
resituates1047753resituates
resize154117723resi__ze
reslated93517523res_lated
reslates83619493res_lates
resolute868513resolute
resonance1147623resonance
resonant8410813resonant
resonants946693resonants
resonator946363resonator
respace11310913res_pace
respade1039573res_pade
respite9513033res_pite
restage83316183res_tage
restated93120173res_tated
restates83423413res_tates
restitute947743restitute
retina65023383retina__
retinal75318353retina_l
retinals85612963retinals
retinas74819353retina_s
retine66237333retin__e
retinene839803retinene
retinites9313493retinites
retint65633443retin_t_
retinted94414363retin_ted
retints74717013retin_ts
retinue75414843retin_ue
retsina74710603retsina__
retsinas8387963retsina_s
reunite7312713re_unite
revibrate1446373revibrate
reviolate1248123reviolate
rexine134719443rexin__e
roseate7613453ros_eate
rostrate8313833rostrate
rosulate8310903rosulate
ruinated939523r_uinated
ruinates8311883r_uinates
ruminated1258663ruminated
ruminates11410193ruminates
runcinate1146473runcinate
rusine63916593rusin__e
rusticate1149033rusticate
selenate81712523selenate
senate63725143__senate
serenate81914873serenate
seriate73722473seri_ate
sinuate7412153__sinuate
spinate93114813_spinate
supinate10310313supinate
teosinte845543teosin_te
terminate11411203terminate
ternate7415483te_rnate
testate73916233tes_tate
uncinate10312393uncinate
urinate7315363_urinate
vaginate123911083vaginate
venenate1147923venenate
vesicae12177703vesica_e
vesicated15117653vesicated
vesicates14119023vesicates

Search took 10 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.250714764.0
2DLD Change Limit1461622539.26615774.0
3Display Results2532530.1102300.0
 (SQL Overall)1786912539.62618563.4
 
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.