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

512 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
straits7491632(None) 
strains74218151strains
strait64025891strait_
traits65121981_traits
kraits104912202_kraits
serails73318362serails
serais64326132serai_s
spaits85017472s_paits
sprains93013592sprains
sprats85819932spra_ts
sprits85122532spr_its
staigs75414812st_aigs
stains64923652st_ains
stairs65416332st_airs
starets73515922starets
starts65423122st_arts
stats55933362st_a_ts
stoats65117482stoa_ts
strafes104516002strafes
straights1345812straights
strain64919572strai_n
straiten838612straiten
straitens946242straitens
straiter8311782straiter
straitest949172straitest
straitly1136562straitly
strakes114218072strakes
strands83711952strands
straps87721782stra_ps
strass67117222stra_ss
strata63616282stra_ta
stratas73013582stratas
strath93216372stra_th
straths102711722straths
strati63518902stra_ti
stratus73011732stratus
straws98718672stra_ws
strays96417932stra_ys
streets73312622streets
striata7379952striata
striate74218952striate
striates83417082striates
strips85719652str_ips
strunts7429542strunts
struts65616802str_uts
tracts85019072_tracts
traiks104013712_traiks
trails64622512_trails
trains64725342_trains
trait56940842_trait_
abstracts1346593abstracts
afrits9311903afr_its
aits46355543___aits
astrals75515243astra_ls
astricts1049463astricts
attains7310983attains
attaints846493attaints
attracts1047793attracts
attrits7310623attrits
awaits96411953_awaits
baits76630583__baits
bracts105617773_bracts
braids95015693_braids
brails84621293_brails
brains85125473_brains
brants85723053_brants
brats75336013_bra_ts
brits76433083_br_its
bruits85714453_bruits
carats85929023cara_ts
crafts115312743_crafts
crits75527573_cr_its
derails84216393derails
derats74625063dera_ts
detracts11138833detracts
detrains9411763detrains
distracts1249293distracts
distrains10411343distrains
distraints1166883distraints
distrait9414343distrait_
distraite10611483distraite
drafts105012533_drafts
drails74716953_drails
drains73719403_drains
drats66628373_dra_ts
droits74314313_droits
entrails8310163entrails
entrains8312963entrains
entrants8311753entrants
errants7410643errants
esprits938393espr_its
estrays10529403estra_ys
estreats839423estreats
estrins7315853estr_ins
extracts1747623extracts
frails93716473_frails
frats86829673_fra_ts
frits86129103_fr_its
fruits94512493_fruits
gaits65726013__gaits
grafts105013253_grafts
grails77518783_grails
grains74223093_grains
grants73722473_grants
gratis74819243_gratis
grits65529583_gr_its
hermits12312143hermits
intrants8312863intrants
introits859713introits
jurants14379213jurants
jurats134213203jura_ts
karats106420503kara_ts
korats105416063kora_ts
krafts13438853_krafts
krait94726773_krait_
krauts10418513_krauts
lariats7615053lariats
merits8320873mer_its
mistrains11511353mistrains
orbits84211443_orbits
outwaits1137493outwaits
parfaits1346913parfaits
permits11314003permits
plaits83816473_plaits
portraits1146803portraits
prats76333393_pra_ts
rafts87820633__rafts
raias54631123__raias
raids65827523__raids
rails55937403__rails
rains55140233__rains
rais45252623__rai_s
raita54623073__raita
raitas64417673__raitas
rants55935343__rants
rats46260373__ra_ts
rebaits9312573rebaits
restrains9311623restrains
restraints1056603restraints
retracts101111313retracts
retrains8314533retrains
saids65328863s__aids
sails55738103s__ails
sains55639973s__ains
saints65122423s__aints
saith85826553s__aith
salts55431883s__alts
sarans64224433sara_ns
sarapes94617753sarapes
sardius839553sardius
sarins63932623sar_ins
saris54544953sar_i_s
satis55633683s__atis
satrapies1147723satrapies
satraps95011643satra_ps
saturants946383saturants
savants1038653savants
scants85219723s_cants
scarts85321493s_carts
scats75930603s_ca_ts
scatts85914663s_catts
schuits1235823schuits
scrags95713803scra_gs
scraich1436763scraich
scraichs1543993scraichs
scraigh1335673scraigh
scraighs1443633scraighs
scrams105216623scra_ms
scrapes116217663scrapes
scrapies124612493scrapies
scraps106017243scra_ps
scrawls12177283scrawls
scries85226823scr_ies
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
seatrains947603seatrains
seats54844343s_ea_ts
secants93413893secants
sennits73811283sennits
seracs84418573sera_cs
serai56830163serai__
serail64222673serai_l
serapes95218103serapes
seraphs12408093seraphs
sereins73716123sereins
serials73919753serials
seriate73722473seriate
seriates82620673seriates
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
serries73925353serries
servants1138003servants
shafts125411443s_hafts
sharias102516003sharias
sharifs13279903sharifs
shits84731173s__hits
shoats94117083shoa_ts
shrifts1335963shrifts
shris84221453shr_i_s
sitarist8315283sitarist
sitarists949373sitarists
sits45050213s___its
skats94621543s_ka_ts
skits94721873s__kits
slants64819083s_lants
slats55436903s_la_ts
slits56128853s__lits
smalts85214893s_malts
smarts86218003s_marts
snails64816653s_nails
snits54124833s__nits
soffits1335093soffits
sonants7511233sonants
soras55041013sora__s
sorbets93012513sorbets
sorites73825243sor_ites
sorties74126403sorties
sorts54536663sor__ts
spails84817823s_pails
spait75631603s_pait_
sparids103512123sparids
spats75031383s_pa_ts
spirants1088283spirants
spirits94112623spirits
spits74429553s__pits
splats84817303spla_ts
splits85416413s_plits
sprags95715823spra_gs
sprain83614863sprai_n
sprangs104610053sprangs
sprat76635973spra_t_
sprawls12176373sprawls
sprays115913643spra_ys
sprigs94814773spr_igs
sprints94113773sprints
sprit76736403spr_it_
sprite84421773spr_ite
sprites94220333spr_ites
spritz174714423spr_itz
sprouts949983sprouts
squats153712963squa_ts
sris45434153s_r_i_s
stabs76221383st_a_bs
stacks124317263st_acks
stacte82113913st_acte
stactes91914633st_actes
stades74626243st_ades
stadias8411113stadias
staffs12349753st_affs
stages75629493st_ages
stags66226743st_a_gs
staid66722083st_ai_d
staig65519643st_ai_g
stain55727943st_ai_n
stair54719943st_ai_r
staithe1037723st_aithe
staithes1138953st_aithes
stakes103927293st_akes
stales65538293st_ales
stalks104614553st_alks
stalls64019933st_alls
stamps105614023st_amps
stands75118053st_ands
stanes64933403st_anes
stangs75018173st_angs
stanks104917703st_anks
stapes85028733st_apes
staphs114411033st_aphs
starers74522313starers
stares66038753st_ares
staring84527053staring
starlets81610083starlets
starlit71512913starlit_
stars55836573st_a_rs
start55642313st_art_
startsy10536703st_artsy
starves104614553starves
stases64225563st_ases
stasis63116873st_asis
stat47352693st_a_t_
state56237333st_a_te
states64337083st_ates
static83118683st_atic
statics93314533statics
statin63921473st_atin
statins73719773statins
statism9412283st_atism
statist7317723st_atist
statists8310163statists
status65515213st_atus
staves94525193st_aves
stays86022023st_a_ys
steadies9311123steadies
steads74116223stea_ds
steaks104415853stea_ks
steals64020063stea_ls
stealth1096453stealth
stealths11104123stealths
steams84916903stea_ms
stearins8312143stearins
steatite8310583steatite
steatites939853steatites
steins64818343st_eins
stents65019453st_ents
sterlets8169273sterlets
sternite8310543sternite
sternites9310073sternites
steroids9911453steroids
stets55423913st__ets
sties55132983st__ies
stilts67915313st_ilts
stimies9316563stimies
stints65119763st_ints
stipites1039653stipites
stirs55921623st__irs
stoai55417873stoai__
stoas55126023stoa__s
stoat57135953stoa_t_
stogies8413693stogies
stoics8311113st_oics
storages9311103storages
storaxes1536883storaxes
stories7324273stories
stotins73213873stotins
stots54828553st__ots
stotts64612863st_otts
stouts65019003st_outs
strafe95215983stra_fe
strafed114413333strafed
strafer103912463strafer
strafers11379913strafers
strafing122111193strafing
straight1249183straight
strained9412253strained
strainer8512223strainer
strainers9510403strainers
straitness1046293straitness
strake104017393stra_ke
straked125415343straked
stramash1344573stramash
strand74514823stra_nd
strang75718313stra_ng
strange85416343strange
stranges94516763stranges
strap77925263stra__p
strappy14205263strappy
strasses81311443strasses
stratal72710603stratal
stratify1445703stratify
stratous8410703stratous
stratum9318253stratum
stratums10266813stratums
stravaigs1342723stravaigs
straw813321293stra__w
strawed114813623strawed
strawier1137493strawier
strawiest1237223strawiest
strawing122411623strawing
strawy1210312823stra_wy
stray88525573stra__y
strayed114513283strayed
strayer104312503strayer
strayers113510143strayers
straying122912693straying
streaks114411273streaks
streams94713373streams
streeks11378713streeks
streels73811343streels
street64125773street_
streps86218063str_eps
stress66616673str_ess
stretta737303stretta
strettas846433strettas
strette7310763strette
stretti747923stretti
stretto737733stretto
strettos847123strettos
strews96817103str_ews
stria55723213str_i_a
striae65422273str_iae
striated93414153striated
striatum1044473striatum
strick124813203str_ick
stricks134310693stricks
strict84821043str_ict
stride75420963str_ide
strides84520393strides
strife95318363str_ife
strifes104716583strifes
strigils946853strigils
strike105619733str_ike
strikes114719093strikes
string75327563str_ing
strings84617133strings
strip77524343str_i_p
stripe85822443str_ipe
stripes95320573stripes
stript85222193str_ipt
stripy115812743str_ipy
strive95020963str_ive
strives104119373strives
strobes93813263strobes
strobils1046563strobils
strokes114316323strokes
strolls739183strolls
strops86220383str_ops
strouds837803strouds
strows96718273str_ows
stroys95914603str_oys
strumas9419833strumas
strums84716453str_ums
strunt64918913strunt_
strut56030733str_ut_
studies82413863studies
studios8256643studios
stunts65615253st_unts
stupids1035273stupids
sturdies92110273sturdies
sturts63915143st_urts
stylets10369213stylets
stylist102110283stylist
stylists11207023stylists
stylite10219613stylite
stylites11168693stylites
stymies1239213stymies
styraxes1833493styraxes
submits1139753submits
subtracts1346363subtracts
suits55028053s__uits
summits1137983summits
surahs94515543sura_hs
suras55336333sura__s
surfeits1146223surfeits
sutras64818593sutra__s
swails94913123s_wails
swains94513953s_wains
swats85726863s_wa_ts
sweats94814613swea_ts
tacts76524123_t_acts
tails55634193_t_ails
tains54936323_t_ains
taints64520533_t_aints
tarots66422993_tarots
tarts57242023_t_arts
tats46858133_t_a_ts
tauts56125513_t_auts
teats55636813_tea_ts
terais64023513terai_s
territs72714503territs
titrants838483titrants
tits46145053_t__its
toasts65914993_toasts
toits55327473_t_oits
traces85329933_traces
tracks124818843_tracks
tract75635713_tract_
trades75724503_trades
tragics10338083_tragics
tragus749233_tragus
traik95418203_trai_k
trail55126773_trai_l
train56529113_trai_n
traipse935873_traipse
traitor7310123_traitor
traitors8310793_traitors
tramps105114453_tramps
trams75327673_tra_ms
tranks104017763_tranks
tranqs155210313_tranqs
trans54933043_tra_ns
transits8313503_transits
trapes85024463_trapes
traps75727483_tra_ps
trapt76433393_trapt_
trass56226473_tra_ss
traves94222743_traves
trawls94412393_trawls
trays85623433_tra_ys
treats64821693_treats
trets55928023_tr_ets
triacs83913223_triacs
triads74513533_triads
trials64319883_trials
tries55742813_tr_ies
trigs65423063_tr_igs
trims75021473_tr_ims
trios55528093_tr_ios
trips74923363_tr_ips
trite54730033_tr_ite
trois57226093_troi_s
trots56629943_tr_ots
trouts66116633_trouts
truants738163_truants
trusts64714433_trusts
trysts9448793_trysts
tsarist7712253tsarist
tsarists857303tsarists
turbits969233turbits
twains95811183_twains
twats86616603_twa_ts
twits86015793_t_wits
tyrants1037453tyrants
ultraist849633ultraist
ultraists947333ultraists
vitrains1138283vitrains
waits88333523__waits
worrits10258683worrits
wraith1258603_wraith
wraiths1355033_wraiths
writs86624383_wr_its

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.436409841.7
2DLD Change Limit1340275126.67320085.0
3Display Results5125120.1703011.8
 (SQL Overall)1786915127.27924548.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.