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 “armours” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

230 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
armours938984(None) 
amours83512641a_mours
arbours93910031arbours
ardours8368871ardours
armors85017811armo_rs
armour84411851armour_
armoury12376231armoury
amour75014852a_mour_
arbors84717872arbo_rs
arbour84211322arbour_
ardors74416862ardo_rs
ardour74110892ardour_
armers85520272arm_ers
armfuls1275012armfuls
armoire938132armoire
armoires1057622armoires
armor75118052armo_r_
armorers10288962armorers
armory114211472armo_ry
armoured1165222armoured
armourer1054882armourer
armourers1154062armourers
armouries1146232armouries
armure8710132arm_ure
armures9510272arm_ures
awmous1157712awmou_s
harbours1346902harbours
humours1286412humours
paramours1345642paramours
parlours1036152parlours
ramous8417102ramou_s
rumours976362rumours
tumours976732tumours
abhors11410623abho_rs
actors81016753acto_rs
adjourn1563423adjourn
adjourns1662853adjourns
adnouns835453adnouns
agamous1037923agamou_s
aimers84621913aim_ers
algors7312553algo_rs
almners9399563almners
almonds10127953almonds
almoners1068133almoners
almonry12104733almonry
almuds9378773alm_uds
almugs9396423alm_ugs
ambers104519573a_mbers
ameers84015573a_meers
amirs75924923a_m_irs
ammos94815823ammo__s
amoks11413553a_mo_ks
amoles84122193a_moles
amort75832203a_mo_rt
amount8414483a_mount
amounts937043a_mounts
ampuls1098893a_mpuls
amus65529613a_m_u_s
arbor74818113arbo_r_
arbores94016033arbores
arboured1156253arboured
archers124414573archers
arcus76918863ar_cu_s
ardor64617863ardo_r_
arduous837603arduous
arenous7314183arenou_s
areolas71013863areolas
areoles71016953areoles
argols74514613argo_ls
argons75018203argo_ns
argots74116023argo_ts
arguers8489023arguers
argues74516413ar_gues
argus66716543ar_gu_s
ariosos7409853ariosos
arkoses113910833arkoses
armadas1038173armadas
armature10106953armature
armatures1166953armatures
armer76924443arm_er_
armets84918353arm_ets
armful1167163armfu_l
armholes1347383armholes
armies85123693arm_ies
armigers1135703armigers
armings103811493armings
armless9369943armless
armlets94610063armlets
armloads1144233armloads
armlocks1643963armlocks
armored102610473armored
armorer9259903armorer
armories10313653armories
armouring1244983armouring
armpits1157123armpits
arms66137493arm___s
aroids75118223ar_oids
aromas81018613ar_omas
around72712413ar_ound
arouse65019983ar_ouse
arousers84810973ar_ousers
arouses74921293ar_ouses
arrears738843arrears
arrobas969213arrobas
arrows92813483arro_ws
arroyos1036533arroyos
arsons63917213arso_ns
arums75517833ar__ums
arvos86015663arvo__s
augurs7399963a_ugurs
aurous64119263aurou_s
auteurs7137503auteurs
brumous11107433brumou_s
candours11408613candours
carious93320283cariou_s
clamours1255963clamours
clours85215083_clours
colours95913413colours
comous10816503comou_s
cormous11312353cormou_s
croups104312553cr_oups
cruors838623cruo_rs
cymous1388403cymou_s
demurs939773dem_urs
detours858033detours
devours1166643devours
dimouts1037893dimouts
dolours8438813dolours
drouks1137123dr_ouks
dyvours1453183dyvours
enamours1044653enamours
errors63311313erro_rs
faitours1134253faitours
famous11412393famou_s
farceurs13464723farceurs
farmers124315263farm_ers
favours13437083favours
femurs1136713fem_urs
fervours1453053fervours
flours94414053_flours
fours85521493__fours
giaours834563giaours
glamours1184723glamours
groups94210513gr_oups
grouts75015613gr_outs
grumous1086603grumou_s
harbors12412413harbo_rs
harbour1247053harbour_
harmers124116593harm_ers
haviours1443833haviours
honours10339353honours
hours85422383__hours
humors11129633humo_rs
humour11116753humour_
inpours936413inpours
labours9349883labours
lemurs837253lem_urs
lours55125293__lours
marmots11311513marmo_ts
memoirs1136803memoirs
mohurs1135933__mohurs
moors74923143__moors
mors65950063__mo_rs
moues75732843__moues
mourn77215013__mourn
mourns84111013__mourns
murmurs1134523murm_urs
odours7418233_odours
ormers84316143orm_ers
ormolus934743ormolus
osmous8138183osmou_s
ours47237563___ours
pandours11317983pandours
paramour1246083paramour_
parlors9312913parlo_rs
parlour937263parlour_
parlous9414293parlou_s
parous84024163par_ou_s
paviours1343613paviours
pours74623183__pours
priors83914483prio_rs
ragouts838533ragouts
rammers113715043rammers
ramonas9311093ramonas
ramus76418283ram_u_s
rancours1076703rancours
razors154711653razo_rs
recurs83315803_recurs
repours9310223repours
rigours8206993rigours
rimous8311913rimou_s
roars55622233_r_oars
roues56039353_r_oues
roups75118903_r_oups
routs57133413_r_outs
rumors81110393rumo_rs
rumour8127373rumour_
samburs11369343samburs
santours837173santours
sapours93610613sapours
sarcous9312933sarcou_s
sartors7314953sarto_rs
saviours1154273saviours
savours10389333savours
scours84913583_scours
sours55230503__sours
stours65015623_stours
tabours94110073tabours
tambours1255863tambours
tamburs11288603tamburs
tenours72610053tenours
termors94712773termo_rs
tours55325863__tours
tremors93711213tremo_rs
trouts66116623tr_outs
tryouts1035293tryouts
tumors8810603tumo_rs
tumour8137393tumour_
unmoors945903unmoors
valours10248733valours
vapours12277453vapours
various103113103variou_s
velours10278083velours
vigours11285483vigours
vrouws12494743vr_ouws
warmers124514293warm_ers
warmouth1644143warmouth
warmouths1742853warmouths
warmups1433813warm_ups
yours85217873__yours

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272308.00016753.4
3Display Results2302300.1561474.4
 (SQL Overall)1786912308.31221498.0
 
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.