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

128 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
armoires105762(None) 
armoire938131armoire_
armories10313651armories
admires1038662adm_ires
arbores94016032arbo_res
armies85123692arm_i_es
armored102610472armo_red
armorer9259912armo_rer
armorers10288972armo_rers
armors85017812armo_r_s
armoured1165222armoured
armourer1054882armourer
armourers1154062armourers
armouries1146242armouries
armours9389852armour_s
armures9510272arm_ures
moires8915632__moires
acquires1945403acquires
admire949933adm_ire_
admired1135703adm_ired
admirer1035523adm_irer
admirers1134713adm_irers
admixes1765963adm_ixes
adores74420723a_do_res
affaires1444303affaires
almoners1068133almoners
almonries1156933almonries
ambries111614553a_mbries
amices105018013a_m_ices
amides95722663a_m_ides
amies76837693a_m_i_es
amines84727983a_m_ines
amirs75924923a_m_ir_s
ammines11312673a_mmines
ammonites1348143ammonites
amoles84122193a_mo_les
amosites10311233a_mosites
amours83512663a_mour_s
amperes11313983a_mperes
anomies93316993anomi_es
apomixes1934853apomixes
arabizes1969103arabizes
arbored103811603arbo_red
arborizes2088823arborizes
arbors84717883arbo_r_s
arboured1156253arboured
arbours93910043arbour_s
arbovirus1442973arbovirus
archines133815253archines
archives16399553archives
arcsines104010343arcsines
ardors74416873ardo_r_s
ardours8368883ardour_s
arenites8917103arenites
areoles71016953areo_les
argosies939523argosies
arises65233803ar__ises
arkoses113910833arko_ses
armatures1166983armatures
armers85520273arm_er_s
armholes1347383armholes
armiger1036253arm_iger
armigers1135703arm_igers
armings103811503arm_ings
armlike1348553armlike_
armonicas13106123armonicas
armor75118053armo_r__
armorial1049453armorial
armorials1145653armorials
armoring1149123armoring
armorless1143483armorless
armory114211473armo_r_y
armour84411853armour__
armoury12376233armour_y
armpits1157133armpi_ts
armrest9310163arm__rest
armure8710133arm_ure_
aroids75118223ar_oi_ds
aroints7313133ar_oints
arouses74921293ar_ouses
arrises71617583ar_rises
arrives101311513ar_rives
arsines73518813ar_sines
arteries8321483arteries
aspires9612043a_spires
atomies93918363atomi_es
atomises103514403atomises
atomizes192711433atomizes
attires72312953a_ttires
avodires1244123avodires
barbwires1643643barbwires
bemires113212833bem_ires
bromides13219363bromides
bromines122514253bromines
bromizes21258333bromizes
carmines123617873carm_ines
crores86121163cr_o_res
drumfires1542553drumfires
empires1139853_empires
ermines9416673erm_ines
farmwives2041783farmwives
hardwires1644643hardwires
harmines132715143harm_ines
harmonies141311043harmonies
harmonises15148373harmonises
harmonizes24147593harmonizes
marmites122212793marm_ites
memoirs1136803memoir_s
memories121214353memories
mires75640883__m_ires
moire71017323__moire_
mores76249643__mo_res
oroides8311973or_oides
prefires134313283prefires
prewires133811013prewires
priories10312453priories
promines123018803promines
promises122916763promises
ramies84630463ram_i_es
rampikes1635393rampikes
refires104820313_refires
rehires105016113_rehires
retires74726213_retires
rewires104717113_rewires
rimfires1344203rimfires
sautoires944803sautoires
umpires1137813_umpires
vampires15226033vampires

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621286.53022383.2
3Display Results1281280.0502560.0
 (SQL Overall)1786911286.98625578.4
 
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.