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

266 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
hoar7672916(None) 
boar66134291boar
haar77323491haar
hear76143881hear
hoard94918311hoard
hoars85925541hoars
hoary114516761hoary
hoax147718291hoax
hoer76533981hoer
hora76136551hora
hour75827311hour
oar37057951_oar
roar46328571roar
soar46838671soar
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
bar58070552_bar
bear66844642bear
boa56954032boa_
board85523002board
boars75229602boars
boart78835932boart
boas66150832boas
boat66360312boat
bolar75123472bolar
boor66130682boor
bora66141632bora
boyar106013762boyar
car59165562_car
char95132152char
choir105313592choir
coal66939252coal
coat67558342coat
coax136922972coax
coir66327242coir
cor59960942co_r
czar156013132czar
dear55343602dear
doat56947672doat
doer57734702doer
door56928512door
dor47253922do_r
dorr56627722dorr
dour56330432dour
ear36867882_ear
far67762602_far
fear75337792fear
fiar76427332fiar
foal76630922foal
foam97127172foam
for66952072fo_r
fora75937392fora
four76226862four
gar47259902_gar
gear55934972gear
gnar56021382gnar
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goer56827102goer
gor47848262go_r
guar56923292guar
ha510259942h_a_
haaf106227732haaf
haars85620472haars
had77658762h_ad
hae67364002h_ae
hag77255742h_ag
hah910655222h_ah
hair76330142hair
haj138140602h_aj
ham86363282h_am
hao67251122h_ao
hap87360052h_ap
hard85443502h_ard
hare76255732h_are
hark115237392h_ark
harl75740002h_arl
harm95637792h_arm
harp96134282h_arp
hart76865772h_art
has67372652h_as
hat67289962h_at
haw97153272h_aw
hay97358772h_ay
head87137172head
heal75645692heal
heap96432892heap
heard95222752heard
hears86737372hears
heart85440742heart
heat77061422heat
heir77523802heir
her66547812h_er
hilar85418142hilar
ho510258272ho__
hoagy124710472hoagy
hoards104912622hoards
hoarse94411322hoarse
hoaxer16348562hoaxer
hob87550922ho_b
hobo97026082hobo
hobs97038982hobs
hock136031302hock
hod76852462ho_d
hodad10311352hodad
hods87239862hods
hoe67562722ho_e
hoed87837982hoed
hoers85724922hoers
hoes75755732hoes
hog78049062ho_g
hogan97817702hogan
hogg96617532hogg
hogs87139662hogs
hoke115935932hoke
holard10410572holard
hold86235062hold
hole77553392hole
holk116027942holk
holm95628102holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
home98042442home
homer105828452homer
homo96126472homo
homy126623222homy
hon67759382ho_n
honan85319772honan
hone77549322hone
honer85332092honer
hong85833952hong
honk116931192honk
honor85718622honor
hons77350782hons
hood85132332hood
hoof106036582hoof
hook116133282hook
hoop96129982hoop
hoot75752092hoot
hop87554592ho_p
hope96639672hope
hoper105829142hoper
hops97942632hops
horah117922042horah
horal86328672horal
horary12310382horary
horas86333092horas
horn76735612horn
hos68364192ho_s
hose76547242hose
hoser811529762hoser
host77852832host
hot67776052ho_t
hots78349322hots
houri85915232houri
hours85422382hours
hove107132222hove
hover115524132hover
how97252432ho_w
howe106734102howe
howf136127202howf
howk145221962howk
howl107625692howl
hows106345602hows
hoy97447912ho_y
hoya107418372hoya
hoyas115016162hoyas
hoys107733932hoys
hwan105716892hwan
izar136616012izar
jar107646152_jar
jowar155211432jowar
kbar106514652kbar
knar85818722knar
koa76737772koa_
koan85425032koan
koas85635092koas
kor76538892ko_r
kora86431552kora
kyar116916842kyar
lar37967532_lar
lear47045952lear
liar47229682liar
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
lobar7313012lobar
lour45430682lour
maar66025052maar
mar57965942_mar
moa57249182moa_
moan65832012moan
moas65545342moas
moat66352032moat
molar75223092molar
moor66628552moor
mor56855002mo_r
mora66641272mora
near45236502near
noir46722432noir
nor38048822no_r
oaf65952882_oaf
oak76238652_oak
oars46846032_oars
oat39888262_oat
or27354732_o_r
ora37250832_ora
osar46820952osar
our36042892_our
par57467022_par
pear69745232pear
polar75623452polar
poor65630222poor
pour611527472pour
rear45644552rear
road56332112road
roam67132412roam
roan47234202roan
roars55622232roars
scar66434202scar
sear47353842sear
shear85424832shear
shoal83920262shoal
shoat85633942shoat
shoer84722152shoer
shofar1236302shofar
soak87227662soak
soap65831132soap
soars54732512soars
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sora45746912sora
sour45935892sour
sowar85821342sowar
spar65433302spar
star48037762star
tar37570692_tar
tear45242882tear
toad55830182toad
tolar55524112tolar
tor39261682to_r
tora47545992tora
torr45630902torr
tour45530372tour
tsar47819802tsar
tzar136315372tzar
var66148332_var
volar86917412volar
war67262422_war
wear75836722wear
whoa106615202whoa_
woad85523942woad
yar67253832_yar
year76534252year
your78623432your
zoa128529992zoa_

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.0762351197.4
2DLD Change Limit298722661.72017367.4
3Display Results2662660.1262111.1
 (SQL Overall)1786912661.92292971.4
 
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.