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

256 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
earls5612751(None) 
carls77037421carls
earl45838141earl_
early85324121early
earns55927561earns
ears46356591ear_s
farls85731111farls
harls85634501harls
jarls126120961jarls
marls75535161marls
pearls84715391pearls
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
beards94116672beards
bears75739042bear_s
birls74023162birls
burls74228852burls
byrls105711232byrls
calls75634732calls
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carl65144782carl_
carle74535702carle
carles85435082carles
carns75937562carns
carols85124982carols
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
cauls75727772cauls
ceorls848162ceorls
curls74927102curls
dahls95012282dahls
dals57145122da_ls
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
deals65435342dea_ls
dearly104615322dearly
dears65736882dear_s
dirls64720502dirls
eagle64219482eagle
eagles73819162eagles
eagres74014572eagres
ear36867882ear__
eared65139502eared
earfuls1036862earfuls
earlap837182earlap
earlaps936392earlaps
earless74316072earless
earn46737552ear_n
earth85023052earth
earths95014592earths
easels65914552easels
eases56041612eases
easts57530322easts
eats47054872ea_ts
eaves85231992eaves
ecrus75113862ecrus
eels46536742e_els
ells46431352e_lls
els37645722e__ls
emails84412342emails
enols54718402enols
enrols61213382enrols
eras45441502e_ras
ergs55523812e_rgs
erns45428222e_rns
eros45238452e_ros
errs45622532e_rrs
ers36046282e_r_s
euros54920242euros
evils84114262evils
eyras84715922eyras
eyres84921772eyres
fails85631482fails
falls85727652falls
fards96629842fards
fares85852872fares
farl76338552farl_
farle86929242farle
farles96025782farles
farms106324952farms
faros85532022faros
farts88336842farts
fears84829392fear_s
ferals94216642ferals
furls85322052furls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
garbs86321412garbs
gars55750742gar_s
gears64628692gear_s
girls64518392girls
gnarls74210772gnarls
hails85231642hails
halls85633782halls
hards96435652hards
hares86255542hares
harks126333432harks
harl75740002harl_
harms106829012harms
harps105926872harps
harts88441592harts
hauls86123732hauls
heals85733452hea_ls
hears86737372hear_s
hearts96218942hearts
herls85226432herls
hurls86522712hurls
jails125422942jails
jarl115828132jarl_
jars117338352jar_s
kails95525212kails
karns96624142karns
karts97630112karts
lalls55324132lalls
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
learns65513742learns
lears55938732lear_s
mails76037782mails
malls76233432malls
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marl66341622marl_
marly106925612marly
mars66261872mar_s
marts77442232marts
mauls76524952mauls
meals75933372mea_ls
merls77423902merls
nails55730402nails
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
nearly94813732nearly
nears55529422near_s
nurls55519682nurls
oars46846032oar_s
orals55826482orals
pails75833062pails
palls74332562palls
pals66951352pa_ls
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parle75836162parle
parles86334402parles
parols84722612parols
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawls105617662pawls
peals75235492pea_ls
pearl75324462pearl_
pearly116414842pearly
pears75138612pear_s
purls74723352purls
rails55937402rails
rares55247442rares
reals55038652rea_ls
rearms85114652rearms
rears54739652rear_s
sails55738102sails
sals46851672sa_ls
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sauls55128122sauls
seals54839692sea_ls
sears54744912sear_s
snarls64016872snarls
taels56822072taels
tails55634192tails
talls55133432talls
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
teals56234132tea_ls
tears55436462tear_s
tirls54519802tirls
vails85825932vails
varas86028192varas
vars75742072var_s
varus85921182varus
veals84926192vea_ls
virls85618602virls
wails86631482wails
walls85529382walls
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
wauls86120552wauls
wawls115416472wawls
weals85428742wea_ls
wears86030302wear_s
yards95324612yards
yarns85621792yarns
yawls114613602yawls
yearly125210272yearly
yearns9509542yearns
years84527672year_s
zarfs174713622zarfs
zeals145320852zea_ls

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.296603685.8
2DLD Change Limit538002561.78030224.7
3Display Results2562560.0803200.0
 (SQL Overall)1786912562.15682880.8
 
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.