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

213 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
jarls12612096(None) 
carls77037421carls
earls56127511earls
farls85731111farls
harls85634501harls
jails125422941jails
jarl115828131jarl_
jars117338351jar_s
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
birls74023162birls
burls74228852burls
byrls105711232byrls
calls75634732calls
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carl65144782carl_
carle74535702carle
carles85435082carles
carns75937562carns
carols85124982carols
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
cauls75727772cauls
curls74927102curls
dahls95012282dahls
dals57145122da_ls
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
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
hails85231642hails
halls85633782halls
hards96435652hards
hares86255542hares
harks126333432harks
harl75740002harl_
harms106829012harms
harps105926872harps
harts88441592harts
hauls86123732hauls
herls85226432herls
hurls86522712hurls
jabs135830092ja_bs
jacals1539872jacals
jacks185219832jacks
jades135222112jades
jaggs148111492jaggs
jagras1438462jagras
jags126132792ja_gs
jail115529092jail_
jakes165023642jakes
jambs166014622jambs
jams135231072ja_ms
janes124928122janes
japes146322822japes
jar107646152jar__
jarfuls1754772jarfuls
jatos125116822jatos
jauks165412462jauks
jaups144810532jaups
javas155915422javas
jaws145027292ja_ws
jays146328342ja_ys
jells125522162jells
jerks166514892jerks
jills125122822jills
jowls156214522jowls
jurels133710582jurels
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
purls74723352purls
rails55937402rails
rares55247442rares
sails55738102sails
sals46851672sa_ls
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sauls55128122sauls
snarls64016872snarls
taels56822072taels
tails55634192tails
talls55133432talls
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
tirls54519802tirls
vails85825932vails
varas86028192varas
vars75742072var_s
varus85921182varus
virls85618602virls
wails86631482wails
walls85529382walls
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
wauls86120552wauls
wawls115416472wawls
yards95324612yards
yarns85621792yarns
yawls114613602yawls
zarfs174713622zarfs

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.313570897.8
2DLD Change Limit538002131.51635488.1
3Display Results2132130.0434953.5
 (SQL Overall)1786912131.87295454.6
 
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.