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

309 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
tear4524288(None) 
bear66844641bear
dear55343601dear
ear36867881_ear
fear75337791fear
gear55934971gear
hear76143881hear
lear47045951lear
near45236501near
pear69745231pear
rear45644551rear
sear47353841sear
tar37570691t_ar
tea37353321tea_
teak85930841teak
teal45546501teal
team66238651team
tears55436461tears
teary85124051teary
teas45851491teas
teat45963631teat
tsar47819801tsar
tzar136315371tzar
wear75836721wear
year76534251year
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
anear55420322anear
ar211379382__ar
attar56516692attar
bar58070552_bar
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
beard86024962beard
bears75739042bears
beat66168302beat
beau66137272beau
beer65635992beer
blear75918682blear
boar66134292boar
car59165562_car
cedar84014322cedar
char95132152char
clear76219052clear
czar156013132czar
dead65434242dead
deaf85838402deaf
deair65817192deair
deal56347412deal
dean56039482dean
dears65736882dears
deary95826842deary
debar85517862debar
deer56739022deer
denar65223292denar
dewar95817732dewar
drear65016902drear
earl45838142_earl
earn46737552_earn
ears46356592_ears
eat36989052_eat
eau37450942_eau
er28345142_e_r
era35741502_era
err35626532_err
eta35834192eta_
etas46432272etas
far67762602_far
feal713940422feal
fears84829392fears
feat76458222feat
fer66646122fe_r
feuar8310242feuar
fiar76427332fiar
gar47259902_gar
gears64628692gears
gnar56021382gnar
guar56923292guar
haar77323492haar
head87137172head
heal75645692heal
heap96432892heap
heard95222752heard
hears86737372hears
heart85440742heart
heat77061422heat
heir77523802heir
her66547812he_r
hoar76729162hoar
izar136616012izar
jar107646152_jar
jean116629282jean
jeer115426462jeer
kbar106514652kbar
kea76540912kea_
keas86337092keas
kebar115113532kebar
keir86217872keir
knar85818722knar
kyar116916842kyar
lar37967532_lar
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leap66032682leap
learn55322662learn
lears55938732lears
leary85927382leary
leas45954182leas
leer46239352leer
lehr75514942lehr
liar47229682liar
maar66025052maar
mar57965942_mar
mead75531602mead
meal65643172meal
mean65538082mean
meat66359602meat
neap66927012neap
nears55529422nears
neat46356782neat
oar37057952_oar
osar46820952osar
ottar54313992ottar
par57467022_par
pea56657242pea_
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
pearl75324462pearl
pears75138612pears
peart76440752peart
peas65755062peas
peat65967932peat
peer66238352peer
per56353092pe_r
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rearm75923562rearm
rears54739652rears
rebar75420192rebar
retear63115482retear
roar46328572roar
scar66434202scar
sea36161292sea_
seal45654372seal
seam66645972seam
sears54744912sears
seas45755272seas
seat47575562seat
seer45547042seer
ser36752402se_r
sera46141392sera
sewar85421092sewar
shear85424832shear
smear74416392smear
soar46838672soar
spar65433302spar
spear75821062spear
star48037762star
stead65520272stead
steak95219802steak
steal56125472steal
steam76322922steam
steer55423862steer
stelar64013862stelar
swear85316852swear
ta211662452t_a_
tab57460322t_ab
tad47959822t_ad
tae38267052t_ae
tael46030712tael
tag47259492t_ag
tahr75217152tahr
taj106442192t_aj
talar56225382talar
tam58663422t_am
tan37167562t_an
tao38358952t_ao
tap57663872t_ap
tare45957622t_are
tarn46842722t_arn
taro46846912t_aro
tarp66936412t_arp
tars46763952t_ars
tart47566182t_art
tas38477102t_as
tat37690292t_at
tatar56122062tatar
tau36856902t_au
tav66043212t_av
taw610155452t_aw
tax109449152t_ax
teach105221122teach
teaks94222902teaks
teals56234132teals
teams75726512teams
teared75722152teared
tearer64822902tearer
tease55428712tease
teaser65421522teaser
teats55636812teats
tech95925442tech
ted46446562te_d
teds54932572teds
tee38366872te_e
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teff106023762teff
teg45741622te_g
tegg65315922tegg
tegs56031492tegs
tel35647902te_l
tela45532972tela
telae54323292telae
tele45040872tele
tell44934702tell
tels46841692tels
temp85323332temp
ten35856112te_n
tend56433772tend
tenor53620252tenor
tens45647412tens
tent46159862tent
tepa66021682tepa
tepal76319582tepal
tepas76521682tepas
terai53525482terai
term66233152term
tern46134802tern
terra54419652terra
terry84721872terry
test48651622test
tet39274982te_t
teth76327882teth
tetra53417952tetra
tetri52716452tetri
tets45847452tets
tew66640152te_w
tews76431642tews
texas126514932texas
text116033932text
thae76825562thae
than76128772than
tharm105916642tharm
that75639322that
thaw107521312thaw
their85512152their
thenar9269992thenar
thir76420542thir
tiara5315902tiara
tier44936142tier
toad55830182toad
toea46732332toea_
toeas55726422toeas
tolar55524112tolar
tor39261682t_or
tora47545992tora
torr45630902torr
tour45530372tour
trad55630912trad
tram67034552tram
trap67532802trap
tray77632592tray
tread64821702tread
treat56240352treat
tsars56717102tsars
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
tweak1257752tweak
tyer75323392tyer
tzars144914272tzars
uptear896782uptear
var66148332_var
veal76936812veal
veer76229572veer
velar85817632velar
vera76828842vera
war67262422_war
weak117126302weak
weal75838682weal
wean75734352wean
wears86030302wears
weary115620612weary
weer75535092weer
weir76019922weir
yar67253832_yar
yea66445752yea_
yeah106725412yeah
yean75834582yean
yearn86316432yearn
years84527672years
yeas78638422yeas
zeal135530332zeal

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 Filter178691298720.0931921408.6
2DLD Change Limit298723091.00029872.0
3Display Results3093090.0764065.8
 (SQL Overall)1786913091.169152858.0
 
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.