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

157 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
army9662418(None) 
arm58449621arm_
arms66137491arms
arty77531311arty
barmy125218761barmy
ably99725132ably
aby810238062a_by
achy126316092achy
acme86924322acme
aery77231682aery
agly86821802agly
agma77623262agma
ahoy101919182ahoy
aim57858212aim_
aims67738182aims
airy75734152airy
alky115920342alky
ally76935642ally
alma66333022alma
alme65832162alme
alms65834922alms
am411875562a_m_
ama510853302a_ma
ami56646802a_mi
ammo85520132ammo
amp77541022a_mp
amu58237322a_mu
amyl95515092a_myl
anomy105113392anomy
any68440482a_ny
ar211379382ar__
arak86929572arak
arame75026622arame
arb510448422ar_b
arbs66834732arbs
arc510250902ar_c
arch98628442arch
arco68331542arco
arcs67834782arcs
are37874572ar_e
area45843392area
ares45871022ares
arf67453372ar_f
arfs76029962arfs
aria46245422aria
arid57642712arid
aril45843022aril
ark77044962ar_k
arks85936872arks
armed86324432armed
armer76924442armer
armet76739452armet
armor75118052armor
armory114211472armory
aroma71220142aroma
array86317142array
ars37670932ar_s
arse46539272arse
art38679142ar_t
arts49650262arts
artsy86012962artsy
arum66129032arum
arums75517832arums
arvo76023432arvo
aryl75922342aryl
ashy107717352ashy
atma68121772atma
atomy107415192atomy
away108024222away
awny105919302awny
awry107619682awry
ay511773892a__y
balmy125217472balmy
barky145721612barky
barm86739602barm_
barms96128462barms
barny105821732barny
bray95232902bray
carny105822922carny
carry105823782carry
cry89726242cr_y
darky136018832darky
demy105422852demy
dormy115817462dormy
dray85428092dray
dry76526032dr_y
early85324122early
elmy95616792elmy
emmy116013242emmy
farcy135217092farcy
farm95934532farm_
farms106324952farms
fray105428902fray
fry96226502fr_y
fumy127118582fumy
gammy135514892gammy
gamy105427532gamy
germy115113662germy
gray85329892gray
grey85624042grey
grimy114312602grimy
hammy155113432hammy
hardy125622062hardy
harm95637792harm_
harms106829012harms
harpy136418202harpy
harry115322952harry
homy126623222homy
immy114611822immy
jammy194810192jammy
karma113415002karma
lardy96119272lardy
larky125218872larky
limy95727712limy
malmy124816342malmy
mammy115215162mammy
marly106925612marly
marry104821692marry
marvy135014032marvy
my78125652__my
narky126017802narky
nary76931222nar_y
orby97519602orby
orgy85218002orgy
palmy126016732palmy
pardy115523952pardy
parry105323752parry
party106630612party
pray96331532pray
prey96228482prey
pry85728052pr_y
racy95825682racy
ram56867272ram_
rami66034092rami
rammy124312492rammy
ramp85934002ramp
rams65950772rams
ray66361992_ray
rimy96621282rimy
sarky125521782sarky
smarmy13629352smarmy
tammy124013222tammy
tardy94720462tardy
tarry85422512tarry
tarty86328182tarty
tray77632592tray
trey77228792trey
troy77429682troy
try66529672tr_y
vary105226062var_y
warm95935672warm_
warmly14228062warmly
warms107726852warms
warty119323822warty
wary106740012war_y
wormy137514252wormy
wry96524702wr_y

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit298721570.78038297.4
3Display Results1571570.0463413.0
 (SQL Overall)1786911570.906197230.7
 
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.