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

436 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
striate7421895(None) 
seriate73722471seriate
striae65422271stria_e
striata7379951striata
striated93414151striated
striates83417081striates
muriate9313362muriate
patriate10311932patriate
satiate7315402satiate
seriated92717022seriated
seriates82620672seriates
serrate73017542serrate
sorbate9311732sorbate
sprite84421772spri_te
state56237332st__ate
stomate9313122stomate
strafe95215982str_afe
strait64025892strait_
straiten838612straiten
straiter8311782straiter
straits74916322straits
strake104017392str_ake
strata63616282str_ata
strath93216372str_ath
strati63518902str_ati
strette7310762strette
stria55723212stria__
striatum1044472striatum
strict84821042strict_
stricter1039422stricter
stride75420962stri_de
strife95318362stri_fe
strike105619732stri_ke
stripe85822442stri_pe
stript85222192stript_
strive95020962stri_ve
stylate10179772stylate
suricate10312612suricate
triage72812892_triage
triste63818642_triste
trite54730032_tri_te
variate101316432variate
aerate64830553aer_ate
airdate8311323airdate
amirate91115953amirate
artiste73813693artiste
aspirate1039943aspirate
asteriated1177993asteriated
astrict9614793astrict_
astricted1247443astricted
astricts1049463astricts
astride8311973astri_de
astringe938223astringe
atria56022343atria__
atrial65418943atria_l
attrite7311833attri_te
aurate64426473aur_ate
aureate72515283aureate
aviate9315203_aviate
barbate11314543barbate
barite84224813bari_te
berate84729023ber_ate
biseriate1147673biseriate
borate85026153bor_ate
bursate94111203bursate
carate84734003car_ate
carinate103320253carinate
castrate10313863castr_ate
cerate84829463cer_ate
cerite84724873ceri_te
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citr_ate
cordate10315223cordate
crate76537403_cr_ate
create85126383_create
curate85226243cur_ate
curiae84518373curia_e
curite85222943curi_te
curtate9312643curtate
derate74531233der_ate
derivate12311203derivate
deviate11312713deviate
distraite10611483distraite
elutriate945303elutriate
emirate91015833emirate
ergate7315143_ergate
estate64719763est__ate
estimate10912003estimate
estivate111010003estivate
estreat7314813estreat_
estreated1039563estreated
estreats839423estreats
expiate16910593expiate
extricate1869073extricate
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
filiate10414233filiate
foliate10513533foliate
formate123115093formate
frigate11311063_frigate
furcate12310453furcate
grate64932883_gr_ate
gyrate104912523gyr_ate
herniate1148113herniate
intricate11411193intricate
irate55627983_ir_ate
irrigate967633irrigate
irritate867873irritate
iterate71119113iterate
karate105320923kar_ate
labiate91313573labiate
lariat6629043lariat_
lariated91212063lariated
lariats7615053lariats
loricate10310663loricate
lustrate8310443lustr_ate
lyrate94112103lyr_ate
marinate103017783marinate
mediate103415213mediate
metricate1349923metricate
muriated1139793muriated
muriates10312083muriates
muricate12311113muricate
narrate7313493narrate
nervate1039533nervate
nitrate72017013nitr_ate
nitrite72314463nitri_te
norite63221133nori_te
obviate1235783obviate
ocreate93711743ocreate
opiate8513463_opiate
orate55133303_or_ate
ornate6315143_ornate
ostomate1049573ostomate
outrate72323183outr_ate
patriated1238533patriated
patriates11311363patriates
pirate82322883pir_ate
prate75135983_pr_ate
primate111516283_primate
private121513263_private
pyrite11913313pyri_te
radiate83416313radiate
rate45458763__r_ate
riata54618023__riata
rite45849453__ri_te
rostrate8313843rostr_ate
saccate111311763saccate
salivate11310013salivate
samite83020603sami_te
sanitate8612043sanitate
sarape84817573sar_ape
sate45556103s___ate
satiated9311603satiated
satiates8314633satiates
saturate8312813saturate
savate9313783s_avate
scoriae9310903scoria_e
scrape105917573scr_ape
scribe104613533scri_be
scrieve12448333scrieve
script105717903script_
scripted13117553scripted
scripter12137783scripter
scripts11509373scripts
scrive115414943scri_ve
scutate9310323scutate
sedate73019813s_edate
senate63725173s_enate
sensate7311893sensate
septate9511873septate
serape84818413ser_ape
serenate81914883serenate
serfage1138403serfage
serial64625863seria_l
serials73919743serials
seriately1246023seriately
seriatim1049223seriatim
serine65432673seri_ne
serrated92513433serrated
serrates82617023serrates
shrieve13417683shrieve
shrift12413543shrift_
shrifts1335963shrifts
shrike134513243shri_ke
shrine94920053shri_ne
shrive125216953shri_ve
sibilate1049533sibilate
sigmate10710143sigmate
silicate10312623silicate
sinuate7412163sinuate
site47052413s__i_te
situate7410783situate
sixte126216583s__ixte
skate94721553s__kate
skite95120053s_ki_te
slainte738543slainte
slate55438283s__late
smite75224873s_mi_te
solate64526073s_olate
solvate102710213solvate
somite84519373somi_te
sonicate10310933sonicate
sopite84917713sopi_te
sorbates10311103sorbates
sorites73825243sori_tes
sororate8411173sororate
spate74731583s__pate
speciate12209583speciate
spicate113214193spicate
spinate93114813spinate
spite75430663s_pi_te
spoliate1039243spoliate
sprat76635973spr_at_
sprats85819933spr_ats
springe103913983springe
sprint84526793sprint_
sprinted113411163sprinted
sprinter103810813sprinter
sprints94113773sprints
sprit76736403spri_t_
sprites94220333spri_tes
sprits85122533spri_ts
spritz174714423spri_tz
stacte82113913st_acte
stade64825303st__ade
stage65330193st__age
stagnate947243stagnate
staithe1037723staithe
stake95927533st__ake
stale55637103st__ale
staminate1187983staminate
stane55933003st__ane
stare54440263st__are
stargaze1844553stargaze
stat47352693st__at_
stated75427833st__ated
stater64427563st__ater
states64337083st__ates
stats55933363st__ats
statue66015323st__atue
statute7419323statute
stave85324993st__ave
stearate839723stearate
stelae63716483stela_e
stellate8310503stellate
sterile7316603steri_le
sternite8310543sternite
stifle93611903st_ifle
stile54931573st_i_le
stilt54831983st_ilt_
stilted83511473st_ilted
stilts67915313st_ilts
stime76521803st_i_me
stint57037663st_int_
stinted82914193st_inted
stinter73614513st_inter
stints65119763st_ints
stipe76523373st_i_pe
stipitate1144613stipitate
stoae55024263st_oa_e
stoat57135953st_oat_
stoats65117483st_oats
stomata938533stomata
stomates10313343stomates
storage8310473storage
stowage1136703stowage
strafed114413333str_afed
strafer103912463str_afer
strafes104516003str_afes
strain64919573str_ain
strained9412253strained
strainer8512223strainer
strains74218153strains
straitens946233straitens
straitest949173straitest
straitly1136563straitly
straked125415343str_aked
strakes114218073str_akes
strand74514823str_and
strang75718313str_ang
strange85416343strange
strap77925263str_a_p
straps87721783str_aps
strass67117223str_ass
stratal72710603str_atal
stratas73013583str_atas
strategy1244363str_ategy
straths102711723str_aths
stratum9318253str_atum
stratus73011733str_atus
stravage1245563stravage
straw813321293str_a_w
strawed114813613str_awed
straws98718673str_aws
strawy1210312823str_awy
stray88525573str_a_y
strayed114513283str_ayed
strayer104312503str_ayer
strays96417933str_ays
streak104613623strea_k
streaked13228453streaked
streaker12229483streaker
streaks114411273streaks
streaky14447813streaky
stream84717293strea_m
streamed11258903streamed
streamer10239513streamer
streams94713373streams
streamy12509483streamy
street64125773street_
streets73312613streets
stretta737293stretta
stretti747913stretti
stretto737733stretto
striating10914193striating
striation9313483striation
strick124813203stri_ck
stricken1436893stricken
strickle1467793strickle
stricks134310693stricks
strictest1147293strictest
strictly1345813strictly
stricture1145903stricture
stridden1044273stridden
strider84315723strider
strides84520393strides
stridor8467393stridor
stridulate1144993stridulate
strifes104716583strifes
strigil837263strigil
strigose945583strigose
striker113714173striker
strikes114719093strikes
string75327563stri_ng
stringed102911873stringed
stringer93812943stringer
strings84617133strings
stringy114111073stringy
strip77524343stri__p
striped105214363striped
striper94514793striper
stripes95320573stripes
stripier1058863stripier
stripped1357093stripped
stripper1247123stripper
strips85719653stri_ps
stripy115812743stri_py
strived114713663strived
striven103910753striven
striver104315203striver
strives104119373strives
strobe84513813str_obe
strode75215973str_ode
stroke105116173str_oke
stromata1047593stromata
strophe1239143strophe
strove95014793str_ove
strumae9368093strumae
strunt64918913strunt_
strunted957243strunted
strunts7429543strunts
strut56030733str_ut_
struts65616803str_uts
strutted946343strutted
strutter846503strutter
stylite10219613stylite
sublate9315363sublate
suite54829563s_ui_te
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
supinate10310313supinate
surbase939793surbase
surface1238653surface
suricates11311743suricates
surname937603surname
syrette1037183syrette
syringe11349473syringe
tate44748603_t__ate
ternate7415483ternate
tirade7311693_tirade
titrate72215573titr_ate
togate74515683_togate
trace75829613_tr_ace
trade65026043_tr_ade
trait56940843_trait_
traits65121983_traits
trave85223033_tr_ave
treat56240353_treat_
treated83618703_treated
treater74219833_treater
treats64821693_treats
treaty94414353_treaty
triable92515393_triable
triac74116373_tria_c
triacs83913223_triacs
triad65217723_tria_d
triads74513533_triads
triaged92810443_triaged
triages82613793_triages
trial54926353_tria_l
trials64319883_trials
tribade1037293_tribade
tribe74420273_tri_be
tribute937313_tribute
trice75127493_tri_ce
triene64316383_triene
trifle94012883_trifle
trijet133916553_trijet
trike95320163_tri_ke
trine54734603_tri_ne
triode75311893_triode
triose64715383_triose
tripe75425383_tri_pe
triple84215923_triple
tristate8311033_tristate
triter65120593_tri_ter
triune64210183_triune
trivet93721883_trivet
tryste9399583_tryste
tubate82813173_tubate
uprate83916543upr_ate
urate55432163_ur_ate
urinate7315363_urinate
urticate1049863urticate
ustulate868323ustulate
utricle937913utricle
variated121211393variated
variates111214983variates
verite94323443veri_te
virgate1138733virgate
vitiate103412953vitiate
write85522833_wri_te

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 Limit1340274366.90619407.3
3Display Results4364360.1732520.2
 (SQL Overall)1786914367.48523873.2
 
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.