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

402 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
stool55619891st_ool
stroll6311601stroll
strook10410301strook
drool65416102_drool
estriol747552estriol
school11410722school
scroll8310162scroll
scroop10299772scroop
shool84523142s_hool
snool55118642s_nool
spool75219042s_pool
stanol6310722stanol
sterol6613322sterol
stood65517712st_ood
stook95218212st_ook
stools65117022st_ools
stoop75821542st_oop
streel64214022streel
strobe84513812strobe
strobil936952strobil
strode75215972strode
stroke105116172stroke
strolls739182strolls
stroma84313072stroma
stromal93010582stromal
strong74914882strong
strop77422242str_op
strops86220382strops
stroud7310382stroud
strove95014792strove
strow88920572str_ow
strown96812092strown
strows96718272strows
stroy87720392str_oy
stroys95914602stroys
tool46735682_t_ool
triol55521362_triol
troll54416532_troll
troop76417532_troop
trooz145016152_trooz
aerosol747683aerosol
argol65317263_argol
astral66919283astr_al
atoll57913923at_oll
atrial65418943atrial
babool103012153babool
befool1137713befool
broil74918223_broil
broo65129823_broo_
brood84620243_brood
brook114717763_brook
broom95022213_broom
broos75126413_broos
carol75128613car_ol
carpool1139223carpool
cool66940493__cool
crook115217573_crook
croon75522783_croon
dewool1047403dewool
droll65415403_droll
drools74412813_drools
drooly104911073_drooly
droop85814823_droop
enrol51014283enr_ol
enroll61110073enroll
enroot6615993enroot
estral64716513estr_al
estriols856253estriols
estrone7413953estrone
estrous7712533estrous
estrual7367933estrual
fool75330593__fool
formol112910333formol
girosol885303girosol
groom85317983_groom
growl96115823_growl
karoo92519583karoo_
karoos102415803karoos
kroon94514483_kroon
maroon83118203maroon
mool67533863__mool
nerol51017813ner_ol
oestriol845373oestriol
outfool1037333outfool
outroll749303outroll
outroot7516563outroot
parol74826273par_ol
patrol83213023patr_ol
patroon92811973patroon
petrol82714063petr_ol
pool65835953__pool
proof105221533_proof
prowl105615123_prowl
pyrrol1136273pyrrol
reroll6412683reroll
reroof9315003reroof
restroom1047573restroom
retool63914483retool
roil46235293__roil
roll46331653__roll
rood56733003__rood
roof75738833__roof
rook85532033__rook
room66235083__room
root45655923__root
rotl45029683__rotl
safrol937283safrol
salol55222143s_alol
saloon64418023saloon
saloop84212583saloop
santol64515243santol
sargo65424413sargo_
sargos74318273sargos
sarod65325873sar_od
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063sar_os
sartor6313873sartor
schools1249113schools
schorl1179803schorl
scoop95617163s_coop
scoot75729143s_coot
scowl1012012973s_cowl
scrawl11208083scrawl
scrod85115063scr_od
scrods94111603scrods
scrolls938063scrolls
scrooch1444953scrooch
scrooge1037173scrooge
scroops11288243scroops
scrota8310183scrota
scrotal938483scrotal
serail64222673serail
seral56336383ser_al
serial64625853serial
sermon8413553sermon
serosa6313023serosa
serosal7311143serosal
serous65023553serous
serow86720443ser_ow
serows96016393serows
serval93913413serval
servo84516683servo_
servos93812723servos
sheol84318363s_heol
sheroot10414373sheroot
shnook1366333shnook
shoal83920263s_hoal
shoo75929883s_hoo_
shook124920153s_hook
shools94919003s_hools
shoon84022003s_hoon
shoos84226353s_hoos
shoot84235893s_hoot
shorl84720243s_horl
shrill94712303shrill
shroff1538493shroff
shroud1038763shroud
shrove125412223shrove
simoom1037493simoom
simoon858063simoon
skatol1035713skatol
skoal93811453s_koal
sloop76118913s_loop
snood64616163s_nood
snook95115573s_nook
snools65715873s_nools
snoop75317173s_noop
snoot55030133s_noot
soil46138823s__oil
sokol94612283s_okol
sol37256623s___ol
solo45538943s__olo
sook84933393s__ook
soon46240503s__oon
soot45761053s__oot
sordor7310213sordor
sorel56231443sor_el
sorgo64719723sorgo_
sorgos74514663sorgos
sororal7310653sororal
sorrel6413543sorrel
sorrow9339443sorrow
sotol54917643s_otol
soul46435713s__oul
spoil75818643s_poil
spoof105019013s_poof
spook115416043s_pook
spools85115913s_pools
spoon74719443s_poon
spoor75016353s_poor
sporal82915453sporal
sprawl11188063sprawl
sprout8419403sprout
stall54722353st_all
stanols739733stanols
stardom1037763stardom
statal61613223statal
stator64015473stator
steal56125473st_eal
steel55721993st_eel
steno54716863steno_
stenos63915773stenos
stereo65317913stereo_
stereos74314973stereos
sternal73411903sternal
steroid81314853steroid
sterols7313443sterols
stertor7310083stertor
still54922073st_ill
stipel84412123stipel
stoa45425913st__oa
stoae55024263st_oae
stoai55417863st_oai
stoas55126023st_oas
stoat57135953st_oat
stob66724613st__ob
stobs75718233st_obs
stock114417563st_ock
stogy95414083st_ogy
stoic7317243st_oic
stoke94922513st_oke
stole54928813st_ole
stolon64112063stolon
stoma75918273st_oma
stomal85213313stomal
stomp95616663st_omp
stone55431183st_one
stony85818643st_ony
stooge73811663stooge
stooks105115373stooks
stooled84313893st_ooled
stoolie739713st_oolie
stoops85917893stoops
stop66532033st__op
stope74727243st_ope
stops74827283st_ops
stopt76528353st_opt
storax1389783storax
store56333813st_ore
stored75524213stored
storer64721673storer
stores65533643stores
storey95217613storey
stork96819693st_ork
storks106115933storks
storm76520373st_orm
storms85814603storms
stormy115510723stormy
story86723033st_ory
stoss54316343st_oss
stot46347323st__ot
stots54828543st_ots
stott56929783st_ott
stoup75517073st_oup
stour54916743st_our
stout57434053st_out
stove85220253st_ove
stow77325743st__ow
stowp105614233st_owp
stows86622703st_ows
strafe95215973strafe
strain64919573strain
strait64025893strait
strake104017393strake
strand74514823strand
strang75718313strang
strap77925263str_ap
straps87721783straps
strass67117223strass
strata63616283strata
stratal72710603stratal
strath93216363strath
strati63518893strati
straw813321293str_aw
straws98718673straws
strawy1210312823strawy
stray88525573str_ay
strays96417933strays
streak104613623streak
stream84717283stream
streek104111413streek
streels73811343streels
street64125773street
strep77120853str_ep
streps86218063streps
stress66616673stress
strew89220653str_ew
strewn96710003strewn
strews96817093strews
stria55723203str_ia
striae65422273striae
strick124813203strick
strict84821043strict
stride75420963stride
stridor8467383stridor
strife95318363strife
strigil837263strigil
strike105619733strike
string75327563string
strip77524333str_ip
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
strobes93813263strobes
strobic1138243strobic
strobila1044933strobila
strobile1047033strobile
strobili1044933strobili
strobils1046563strobils
stroked124613623stroked
stroker114113513stroker
strokes114316323strokes
strolled937813strolled
stroller848163stroller
strongly1245953strongly
strongyl1243553strongyl
strophe1239133strophe
stroppy14205093stroppy
strouds837793strouds
strowed115312143strowed
stroyed114110863stroyed
stroyer103510773stroyer
struck12489263struck
strudel835783strudel
strum75619443str_um
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733str_ut
struts65616803struts
stull54916273st_ull
stupor836013stupor
subcool1146233subcool
sunroof1047053sunroof
sunroom947013sunroom
sural55931263sur_al
swoon85014783s_woon
swoop105213433s_woop
symbol1336083symbol
taxol124011363_taxol
thiol87616043_thiol
toil46536283_t_oil
toll45535263_t_oll
too38965423_t_oo_
took86531073_t_ook
tools55325243_t_ools
toom66532933_t_oom
toon47740633_t_oon
toot45958883_t_oot
toro48045683_toro_
toros54336193_toros
torot56139943_torot
trail55126773_trail
trawl84915873_trawl
trial54926353_trial
trill55122933_trill
trio45233343_trio_
triols66117803_triols
trios55528093_trios
troak95213573_troak
trock114817603_trock
trod57627953_tr_od
trode65322853_trode
trog57628213_tr_og
trogon73611753_trogon
trogs67022603_trogs
trois57226093_trois
troke94821053_troke
trolls64613943_trolls
trolly94012353_trolly
tromp95815803_tromp
trona54118953_trona
trone55131863_trone
troops85712773_troops
trop66833303_tr_op
trope75725803_trope
trot46351313_tr_ot
troth85622203_troth
trots56629943_trots
trotyl9236673_trotyl
trout57332573_trout
trove85221923_trove
trow78031423_tr_ow
trowel94211463_trowel
trows88826183_trows
troy77429683_tr_oy
troys86418613_troys
trull54012673_trull
uncool8610113uncool
unroll61210073unroll
unroof9410193unroof
unroot6315553unroot
uproot8314123uproot
varoom11411413varoom
vitriol1045693vitriol
vroom105312473_vroom
wool76427373__wool

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164026.92316281.4
3Display Results4024020.2031980.3
 (SQL Overall)1786914027.26624592.8
 
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.