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 “sears” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

394 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
sears5474491(None) 
bears75739041bears
dears65736881dears
ears46356591_ears
fears84829391fears
gears64628691gears
hears86737371hears
lears55938731lears
nears55529421nears
pears75138611pears
rears54739651rears
scars75433531scars
seals54839691seals
seams75731661seams
sear47353841sear_
seas45755271sea_s
seats54844341seats
seers55136381seers
sers45746651se_rs
sewars94018621sewars
shears93820901shears
smears84714431smears
soars54732511soars
spars75431541spars
spears84019471spears
stars55836571stars
swears94114071swears
tears55436461tears
wears86030301wears
years84527671years
afars85716512afars
agars66120642agars
anears63717182anears
ars37670932__ars
bars66564092_bars
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bear66844642bear_
beard86024962beard
beards94116672beards
beats76042242beats
beaus75127112beaus
beers75628392beers
blears85116452blears
boars75229602boars
cars67364762_cars
cedars93312832cedars
chars105936632chars
clears84116562clears
czars164812912czars
deads75726912deads
deairs74013782deairs
deals65435342deals
deans66131392deans
dear55343602dear_
deary95826842deary
debars94218042debars
deers64930522deers
denars74621432denars
dewars105117072dewars
drears74614252drears
ear36867882_ear_
earl45838142_earl
earls56127512_earls
earn46737552_earn
earns55927562_earns
eats47054872_eats
eras45441502_eras
errs45622532_errs
ers36046282_e_rs
escars83913132escars
eskars10357592eskars
fear75337792fear_
feats86432752feats
feuars938652feuars
fiars86720832fiars
gars55750742_gars
gear55934972gear_
gnars66718852gnars
guars65021042guars
haars85620472haars
heads95127112heads
heals85733452heals
heaps105223222heaps
hear76143882hear_
heard95222752heard
hearse94114272hearse
heart85440742heart
hearts96218942hearts
heats85838402heats
heirs85618562heirs
hers75844872he_rs
hoars85925542hoars
izars145112932izars
jars117338352_jars
jeans126022112jeans
jeers124818132jeers
kbars114612602kbars
keas86337092kea_s
kebars124112492kebars
keirs95313672keirs
knars94416112knars
kyars124813962kyars
lars46956572_lars
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lear47045952lear_
learn55322662learn
learns65513742learns
leary85927382leary
leas45954182lea_s
leers54828982leers
lehrs86111132lehrs
liars54723162liars
maars74621632maars
mars66261862_mars
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
neaps75618322neaps
near45236502near_
neats55931902neats
oars46846032_oars
pars67560792_pars
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pear69745232pear_
pearl75324462pearl
pearls84715382pearls
peart76440752peart
peas65755062pea_s
peats76140192peats
peers75130272peers
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rear45644552rear_
rearm75923562rearm
rearms85114652rearms
rebars84019822rebars
roars55622232roars
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
sans45153352s_ans
saps65346372s_aps
sard55344242s_ard
sards64736182s_ards
sari45444042s_ari
saris54544952s_aris
sark84938972s_ark
sarks96632462s_arks
saros55238062s_aros
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419952scads
scags85520972scags
scams94423972scams
scans74625102scans
scar66434202scar_
scare75334462scare
scares85033002scares
scarf105427142scarf
scarfs114714682scarfs
scarp95724102scarp
scarps104718602scarps
scart76139772scart
scarts85321492scarts
scary105222592scary
scats75930602scats
scaurs85512042scaurs
sea36161292sea__
seal45654372sea_l
sealers74323552sealers
seam66645972sea_m
seamers94719432seamers
seamy105921272seamy
search113312422search
seared75232842seared
searer65432022searer
searest73322022searest
seat47575562sea_t
seaters74028932seaters
secpars1138412secpars
secs65033892se_cs
sects75622892sects
sedans74816092sedans
seders74420282seders
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seeps74828752seeps
seer45547042seer_
sees45361052se_es
seggars9377782seggars
segos64919482segos
segs54933882se_gs
seifs85019332seifs
seis45542392se_is
selahs9313212selahs
selfs85220242selfs
sells55134432sells
sels46345982se_ls
semes75731582semes
semis74623532semis
senary93716072senary
sends65528242sends
senors63620782senors
sepals85217372sepals
septs75420602septs
ser36752402se_r_
sera46141392se_ra
serac75925202serac
seracs84418572seracs
serai56830162serai
serais64326132serais
seral56336382seral
sere46153472se_re
seres55448892seres
serf76340112se_rf
serfs84922012serfs
serry84824122serry
sets45549502se_ts
setts55124322setts
severs94121122severs
sewans95215902sewans
sewar85421092sewar_
sewers94719712sewers
sews75836022se_ws
sexes126126222sexes
sexts125118382sexts
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shard96125962shard
shards104319172shards
share86437082share
shares95236412shares
shark126225022shark
sharks135019722sharks
sharn84823702sharn
sharns95516982sharns
sharp104922532sharp
sharps115516082sharps
shaws116226262shaws
shays116021432shays
sheafs124912882sheafs
sheals94420642sheals
shear85424832shear_
sheas86331792shea_s
sheers94322402sheers
shmears1277072shmears
sials54227242sials
sieurs659042sieurs
simars84916932simars
sirs44338332s_irs
sitars65417592sitars
sizars154812622sizars
skags104316072skags
skas85325712ska_s
skats94621532skats
skeans104512912skeans
slabs75322642slabs
slags66525902slags
slams74927902slams
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slurs54123372slurs
smarm95517602smarm
smarms105712532smarms
smart75834092smart
smarts86218002smarts
smear74416392smear_
smeary114110802smeary
snags64421312snags
snaps74719562snaps
snare54429982snare
snares65329032snares
snarf86525422snarf
snarfs95113422snarfs
snark95419942snark
snarks104815732snarks
snarl54921082snarl
snarls64016872snarls
snaws86116362snaws
sneaks104312492sneaks
sneaps84510862sneaps
sneers64016172sneers
soaks95220292soaks
soaps75120712soaps
soar46838672soar_
sofars94712782sofars
sonars64818972sonars
soras55041012soras
sours55230502sours
sowars94318002sowars
spaes76029972spaes
spams94922192spams
spans74528732spans
spar65433302spar_
spare75135562spare
spares84834552spares
spark114920892spark
sparks124616362sparks
sparse84516342sparse
spas67036722spa_s
spats75031382spats
spays105520512spays
speaks125114582speaks
speans85417142speans
spear75821062spear_
speers85019952speers
speirs85013232speirs
spurs74621522spurs
stabs76221382stabs
stags66226742stags
stairs65416332stairs
star48037762star_
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stats55933362stats
stays86022022stays
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
steers63820982steers
stirs55921612stirs
suers55128482suers
sugars7312422sugars
suras55336322suras
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
sward94221462sward
swards105415132swards
sware85828212sware
swarf115324652swarf
swarfs125612062swarfs
swarm106218832swarm
swarms116112162swarms
swart86234642swart
swats85726862swats
sways115518462sways
swear85316852swear_
sweats94814612sweats
tars46763952_tars
teaks94222902teaks
teals56234132teals
teams75726512teams
tear45242882tear_
teary85124052teary
teas45851492tea_s
teats55636812teats
tsars56717102tsars
tzars144914272tzars
users55817572use_rs
vars75742072_vars
veals84926192veals
veers84521362veers
velars93913722velars
wars78659802_wars
weals85428742weals
weans85326742weans
wear75836722wear_
weary115620612weary
weirs84316492weirs
yeahs115214552yeahs
yeans86624882yeans
year76534252year_
yearn86316432yearn
yearns9509542yearns
yeas78638422yea_s
zeals145320852zeals

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538003941.58034050.6
3Display Results3943940.1103581.8
 (SQL Overall)1786913941.783100219.3
 
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.