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

116 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
chairmen1510547(None) 
chainmen15105261chainmen
chairman15106381chairman
airmen82612352__airmen
carmen104019342c_a_rmen
chainman1585192chainman
chaired134211242chair_ed
chairmans1685142chairmans
chairwomen2052502chairwomen
chapmen1637282cha_pmen
charmed154714252cha_rmed
charmer144913662cha_rmer
chirmed15379732ch_irmed
chirren12388742ch_irren
cochairmen1951932cochairmen
aidmen92610373__aidmen
airman82414223__airman
barmen105418533_ba_rmen
cabmen123610653c_a_bmen
caiman103615663c_ai_man
cairn75717513c_air__n
cairned1037643c_airned
careen84119493c_a_reen
carman103920743c_a_rman
carven114716663c_a_rven
cavemen1437143c_avemen
chagrin1337893chagr_in
chain105723673chai___n
chaine115119223chai_ne_
chained133812693chai_ned
chaines124518733chai_nes
chair105519633chair___
chairing143110773chairing
chairmaned1842683chairmaned
chairs114916183chair__s
chairwoman2052713chairwoman
chaise114916413chai_se_
chaises124317493chai_ses
chapman1637893cha_pman
chare105231983cha_r_e_
chared125423693cha_r_ed
chares115631803cha_r_es
charge125114213cha_rge_
charged144614023cha_rged
charger133914063cha_rger
charges134615983cha_rges
charier124317903cha_rier
charked174814013cha_rked
charley15118273cha_rley
charm126124663cha_rm__
charmers154211333cha_rmers
charming163012033cha_rming
charms135218843cha_rm_s
charnel124010053cha_rnel
charred134614483cha_rred
charrier1378683charrier
charted135116853cha_rted
charter123918303cha_rter
charwomen1944593charwomen
chasmed154710173cha_smed
chasten124312403cha_sten
chazzen20214783cha_zzen
chessmen1544463chessmen
chicken18278983ch_icken
chidden14255223ch_idden
chime125322593ch_i_me_
chimed145814833ch_i_med
chimer135517203ch_i_mer
chimes134922573ch_i_mes
chirked173810333ch_irked
chirker16429323ch_irker
chirm125317063ch_irm__
chirming16318643ch_irming
chirms135113983ch_irm_s
chirped15379783ch_irped
chirper14359963ch_irper
chirre114111853ch_irre_
chirred133612123ch_irred
chirres123812253ch_irres
choired13349343choir_ed
choremen1597603choremen
chorten122811303ch_orten
chrismon1544643chrismon
christen13106703christen
claimed12298833clai_med
claimer11279883clai_mer
clansmen1245723clansmen
coachmen1745013coachmen
coarsen93210323coa_rsen
cochairman1951613cochairman
colormen1247243colormen
cragsmen1344763cragsmen
daimen92210573_dai_men
dairymen1443313_dairymen
hackmen1836713_hackmen
haired105117173_hair_ed
hairier103111053_hairier
hairnet10911703_hairnet
hairpin1245413_hairpin
hangmen1337383_hangmen
harden105718533_ha_rden
harken135116343_ha_rken
harmed125218833_ha_rmed
harmer114719553_ha_rmer
harmin113117393_ha_rmin
hitmen11239193_h_itmen
mailmen1137273_mailmen
repairmen1343333repairmen
shagreen1243443shagreen
shairn9269063shair__n
sharpen12389723sha_rpen
shipmen14317283sh_ipmen
thairm1156963thairm__
thairms1244453thairm_s
trainmen1046153trainmen
whalemen1644473whalemen

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.1561145455.1
2DLD Change Limit1461621167.34319904.9
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.54523683.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.