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

315 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
harls8563450(None) 
carls77037421carls
earls56127511earls
farls85731111farls
hails85231641hails
halls85633781halls
hards96435651hards
hares86255541hares
harks126333431harks
harl75740001harl_
harms106829011harms
harps105926871harps
harts88441591harts
hauls86123731hauls
herls85226431herls
hurls86522711hurls
jarls126120961jarls
marls75535161marls
aals49941142_aals
ails45654712_ails
alls46740922_alls
als36663022_a_ls
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arils58732202_arils
arks85936872_arks
arles56735742_arles
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
aryls87015812_aryls
awls75926092_awls
baals76122702baals
bails75933522bails
balls76236412balls
bals66354042ba_ls
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
bawls105719322bawls
bharals1236732bharals
birls74023162birls
burls74228852burls
byrls105711232byrls
calls75634732calls
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carl65144782carl_
carle74535702carle
carles85435082carles
carns75937562carns
carols85124982carols
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
cauls75727772cauls
charas114223612charas
chards125119732chards
chares115631802chares
charks155219702charks
charms135218842charms
charrs115219192charrs
chars105936642char_s
charts115823092charts
churls115411072churls
curls74927102curls
dahls95012282dahls
dals57145122da_ls
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dhals95415442dha_ls
dirls64720502dirls
earl45838142earl_
early85324122early
earns55927562earns
ears46356592ear_s
fails85631482fails
falls85727652falls
fards96629842fards
fares85852872fares
farl76338552farl_
farle86929242farle
farles96025782farles
farms106324952farms
faros85532022faros
farts88336842farts
furls85322052furls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
garbs86321412garbs
gars55750742gar_s
girls64518392girls
gnarls74210772gnarls
haafs115711162haafs
haars85620472haars
habus106317142habus
hacks144928712hacks
hades96035112hades
haems105517012haems
haeres94017032haeres
haes77651022ha_es
haets86525122haets
hafts116219462hafts
hags86740842ha_gs
hahas117118442hahas
hahs108333362ha_hs
haiks125120932haiks
hail74839062hail_
hairs86225172hairs
hajes155420942hajes
hajis156716282hajis
hakes126034302hakes
hakus125114112hakus
halals95018312halals
hale76052832ha_le
hales85449842hales
half106238452ha_lf
hall75741162ha_ll
hallo85127552hallo
hallos95425102hallos
halm95834972ha_lm
halms105225212halms
halo76437322ha_lo
halos85230252halos
halt76056302ha_lt
halts85230102halts
hamals114816822hamals
hames106138702hames
hams96446132ha_ms
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hants86335402hants
haole84820082haole
haoles94919802haoles
haply135915062haply
haps96443462ha_ps
harass9313942harass
hard85443502har_d
hardly135112832hardly
hardy125622062hardy
hare76255732har_e
hared95742182hared
harem104924452harem
harems115513822harems
hark115237392har_k
harlot94422802harlot
harlots103413292harlots
harm95637792har_m
harp96134292har_p
harpy136418212harpy
harry115322952harry
harsh116418052harsh
hart76865772har_t
hartals10313022hartals
has67372652ha__s
hasps105114642hasps
hates86742572hates
hats76858252ha_ts
haul75530452haul_
haulm104415412haulm
haulms11558502haulms
haves116034872haves
hawks155415702hawks
haws106439442ha_ws
hays106138072ha_ys
hazels185710082hazels
hazes174928322hazes
heals85733452heals
hears86737372hear_s
hearts96218942hearts
heels85625532heels
heils85222192heils
hells85032042hells
herbs105520502herbs
herds96424682herds
heres86245902heres
herl75834552herl_
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872her_s
hills85431352hills
hires86134342hires
hoards104912622hoards
hoars85925552hoar_s
hols76946292h_ols
horas86333102horas
horns86125332horns
howls116219222howls
hulls84923562hulls
hurds95219072hurds
hurl76029932hurl_
hurly115819292hurly
hurts86922822hurts
jails125422942jails
jarl115828132jarl_
jars117338352jar_s
kails95525212kails
karns96624142karns
karts97630112karts
lalls55324132lalls
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
mails76037782mails
malls76233432malls
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marl66341622marl_
marly106925612marly
mars66261872mar_s
marts77442232marts
mauls76524952mauls
merls77423902merls
nails55730402nails
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
nurls55519682nurls
oars46846032oar_s
orals55826482orals
pails75833062pails
palls74332562palls
pals66951352pa_ls
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parle75836162parle
parles86334402parles
parols84722612parols
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawls105617662pawls
pearls84715392pearls
pharos11312062pharos
purls74723352purls
rails55937402rails
rares55247442rares
sails55738102sails
sals46851672sa_ls
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sauls55128122sauls
shards104319172shards
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shauls94913112shauls
shawls125411972shawls
shorls94516202shorls
snarls64016872snarls
taels56822072taels
tails55634192tails
talls55133432talls
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
tharms115712242tharms
thirls95012062thirls
thurls9418712thurls
tirls54519802tirls
vails85825932vails
varas86028192varas
vars75742072var_s
varus85921182varus
virls85618602virls
wails86631482wails
walls85529382walls
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
wauls86120552wauls
wawls115416472wawls
wharfs1546372wharfs
whirls124710532whirls
whorls124410162whorls
yards95324612yards
yarns85621792yarns
yawls114613602yawls
zarfs174713622zarfs

Search took 3 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.313570897.8
2DLD Change Limit538003151.72031279.1
3Display Results3153150.0933387.1
 (SQL Overall)1786913152.12684050.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.