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

225 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
yarns8562179(None) 
barns76335141barns
carns75937561carns
darns66927891darns
earns55927561earns
karns96624141karns
tarns56433951tarns
warns87231001warns
yards95324611yards
yarn75230041yarn_
yawns114213271yawns
yearns9509541yearns
ains46158882_ains
airns55521032airns
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
awns75324432_awns
ayins85321612ayins
bairns86710872bairns
banns75321232banns
bans66555132ba_ns
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barn66444642barn_
barny105821732barny
barons85025382barons
bars66564092bar_s
brans75437432brans
burns74926772burns
cains75334302cains
cairns85313302cairns
cans65050842ca_ns
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carn66245432carn_
carny105822922carny
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
corns76034762corns
curns74924272curns
cyans105714812cya_ns
damns84916922damns
dans56748142da_ns
darbs85323262darbs
dares66146702dares
darks106727872darks
darn56434622darn_
darts67635732darts
dawns95916592dawns
durns64819862durns
earls56127512earls
earn46737552earn_
ears46356592ear_s
erns45428222_erns
fans76247362fa_ns
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fauns84516752fauns
fawns115914262fawns
ferns85220082ferns
firns86018542firns
gains65729512gains
garbs86321412garbs
garni6315702garni
gars55750742gar_s
girns64516802girns
grans64832542grans
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
herns84825582herns
horns86125332horns
jarls126120962jarls
jars117338352jar_s
kains96125642kains
kaons95014852kaons
karn86129412karn_
karts97630112karts
kerns94719562kerns
kirns95315452kirns
kyars124813962kyar_s
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
lawns85215422lawns
learns65513742learns
mains75635102mains
mans66354532ma_ns
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
morns75527442morns
naans55815252naans
nans46139392na_ns
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
pains75138282pains
pans65855722pa_ns
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawns108818132pawns
pirns76020092pirns
porns75527342porns
pyrans11411062pyrans
rains55140232rains
rares55247442rares
sains55639972sains
sans45153352sa_ns
sarans64224432sarans
sards64736182sards
sarins63932622sarins
saris54544952saris
sarks96632462sarks
saros55238062saros
sharns95516982sharns
sorns55028412sorns
tains54936322tains
tans46154812ta_ns
tares57456562tares
tarn46842722tarn_
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
terns55226872terns
trans54933042trans
turns55623232turns
urns46323892_urns
vans76236722va_ns
varas86028192varas
varna84516172varna
varnas94212822varnas
vars75742072var_s
varus85921182varus
wains86930862wains
wans76452262wa_ns
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warn75239322warn_
warps107126422warps
wars78659802war_s
warts814840402warts
yacks144419812yacks
yaffs145311122yaffs
yagis95416572yagis
yags86632292ya_gs
yairds10448022yairds
yaks116025202ya_ks
yamens114010822yamens
yams95330732ya_ms
yamuns11336512yamuns
yang85626062ya_ng
yangs95618692yangs
yank115423662ya_nk
yanks125316572yanks
yapons114411772yapons
yaps95933522ya_ps
yar67253832yar__
yard85633252yar_d
yare75636942yar_e
yarer84321572yarer
yarest95018912yarest
yarned105514022yarned
yarner93313062yarner
yarners104312202yarners
yauds95013222yauds
yaups105910742yaups
yawls114613602yawls
yawn106219092yawn_
yawps13628792yawps
yaws105531212ya_ws
yays105728912ya_ys
yeans86624882yeans
yearn86316432yearn_
years84527672year_s
yens75832262y_ens
yerks125416562yerks
yins75335122y_ins
yirds96612512yirds
yirrs8469192yirrs
yores85031322yores
yuans84613322yuans
yurts87216532yurts
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.0931921408.6
2DLD Change Limit538002251.81329674.6
3Display Results2252250.0633571.4
 (SQL Overall)1786912251.96990752.2
 
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.