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

257 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
naris5573529(None) 
laris54737461laris
nabis76020581nabis
narcs76122021narcs
nards65928461nards
nares55544151nares
naric76824171naric
narks96026031narks
nazis145216081nazis
noris54928271noris
paris75145941paris
saris54544951saris
abris75722602abris
ahis76135382_ahis
airs46447422_airs
ais39083572_a_is
amis66445322_amis
anis45746462_anis
antis55033312antis
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
aria46245422_aria
arias55438022_arias
arid57642712_arid
aril45843022_aril
arils58732202_arils
arise56436432_arise
arks85936872_arks
arms66137492_arms
arris56824682arris
ars37670932_ar_s
arsis55722422_arsis
arts49650262_arts
auris55331532auris
axis116127912_axis
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
baric96125692baric
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
basis75429862basis
bris65539612_bris
cadis84428502cadis
capris10415082capris
carbs96031462carbs
cards85137932cards
cares77369182cares
caries85147622caries
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
cris66233432_cris
dais57040702da_is
darbs85323262darbs
dares66146702dares
daric85623122daric
darics94314112darics
darks106727872darks
darns66927892darns
darts67635732darts
earls56127512earls
earns55927562earns
ears46356592ear_s
fairs85825442fairs
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
gadis74825292gadis
garbs86321412garbs
garish104516922garish
gars55750742gar_s
gnarls74210772gnarls
gnarrs7407662gnarrs
gnars66718852gnar_s
hairs86225172hairs
hajis156716282hajis
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
inarms8410092inarms
indris7311962indris
iris45732552_iris
jarls126120962jarls
jars117338352jar_s
kadis105921062kadis
kakis86116842kakis
karns96624142karns
karts97630112karts
kauris103611532kauris
knars94416112knar_s
kris86423602_kris
lairs55425872lairs
lapis76223152lapis
lards65331862lards
lares54852632lares
lari45839152lari_
larks95227812larks
lars46956572lar_s
loris55329152loris
mairs76228302mairs
maras75443292maras
marcs95726622marcs
mares76457632mares
maria75032882maria
marish114319052marish
marks115933482marks
marls75535162marls
mars66261872mar_s
marts77442232marts
mavis105622722mavis
maxis145721562maxis
naans55815252naans
nabes75427092nabes
nabs66236192na_bs
nacres85614452nacres
nadas66320812nadas
nadir61012972nadir
nadirs7109002nadirs
naffs116213962naffs
nags55436022na_gs
naif76839022na_if
naifs87617422naifs
nail45838652na_il
nails55730402nails
naira5314742naira
nairas6312782nairas
nairu5413812nairu
nairus639142nairus
nalas55528362nalas
names74833362names
nanas55928632nanas
nanism8311202nanism
nans46139402na_ns
naoi46024632naoi_
naos47429732na_os
napas75924352napas
napes74828462napes
naps66238582na_ps
narc67127952nar_c
narcism1188732narcism
narcist9512442narcist
narco76718242narco
narcos86714202narcos
nard56634452nar_d
narial6317952narial
narine63422552narine
nark85230062nar_k
narky126017802narky
nary76931222nar_y
nates55238332nates
naves87030382naves
navies95218622navies
nays75931592na_ys
nazi136219872nazi_
nears55529422near_s
nerds65719252nerds
nereis6315342nereis
nerts55924982nerts
noirs55615462noirs
nori47133142nori_
noria55722182noria
norias65518202norias
norms76019312norms
nurds65518522nurds
nurls55519682nurls
oars46846032oar_s
oasis56422552oasis
orris54516552orris
padis86227142padis
pairs75325832pairs
paras76143042paras
pards85634332pards
pares77164482pares
paries84742512paries
parish115022352parish
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
parvis116114802parvis
pavis106422732pavis
peris75537072peris
puris75332022puris
qadis155917852qadis
ragis66325602ragis
rais45252622ra_is
rakis95323442rakis
ranis55235832ranis
rares55247442rares
sadis64930852sadis
sakis95323672sakis
sards64736182sards
sari45444042sari_
sarin55239252sarin
sarins63932622sarins
sarks96632462sarks
saros55238062saros
satis55633682satis
shris84221452shris
snares65329032snares
snarfs95113422snarfs
snarks104815732snarks
snarls64016872snarls
sris45434152_sris
tamis76728732tamis
tapis75028862tapis
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarsi55222172tarsi
tarts57242022tarts
taxis126821972taxis
unais53420772una_is
unarms839242unarms
uraris63817272uraris
vairs85019132vairs
varas86028192varas
varia85824202varia
varias95019902varias
varies94330872varies
varix154313512varix
vars75742072var_s
varus85921182varus
wadis95223962wadis
wairs86424062wairs
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
yagis95416572yagis
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs
zoris145320012zoris

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.310576422.6
2DLD Change Limit538002571.54634799.5
3Display Results2572570.0803212.5
 (SQL Overall)1786912571.93692299.1
 
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.