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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
chairman1510638(None) 
chainman1585191chainman
chairmans1685141chairmans
chairmen15105471chairmen
airman82414222__airman
caiman103615662c_ai_man
carman103920742c_a_rman
chainmen15105262chainmen
chairmaned1842682chairmaned
chairwoman2052712chairwoman
chapman1637892cha_pman
cochairman1951612cochairman
aidman92410623__aidman
airmen82612353__airmen
barman103519703_ba_rman
cabman123812503c_a_bman
caimans113811783c_ai_mans
cairn75717513c_air__n
carmen104019343c_a_rmen
caveman1437073c_aveman
cayman133613213c_a_yman
chacma1537903cha_cma_
chacmas1638003cha_cmas
chagrin1337893chagr_in
chain105723673chai___n
chainsaw1642373chainsaw
chair105519633chair___
chaired134211243chair_ed
chairing143110773chairing
chairmaning1952453chairmaning
chairmanned1951383chairmanned
chairs114916183chair__s
chairwomen2052503chairwomen
chakra15437533chakr_a_
chakras16428503chakr_as
chapmen1637283cha_pmen
charas114223613cha_r_as
charisma1576363charisma_
charismas1655313charismas
charka154011703cha_rka_
charkas164810963cha_rkas
charm126124663cha_rm__
charmed154714253cha_rmed
charmer144913663cha_rmer
charming163012033cha_rming
charms135218843cha_rm_s
charpai1436633cha_rpai
charwoman1944673charwoman
chasmal14158213cha_smal
chazan20269133cha__zan
chazzan20204853cha_zzan
chessman1544823chessman
chiasma14366993chiasma_
chiasmal15285033chiasmal
chiasmas15306593chiasmas
chimar133911473ch_i_mar
chiral114614413ch_ir_al
chirm125317063ch_irm__
chirmed15379733ch_irmed
chirming16318643ch_irming
chirms135113983ch_irm_s
chirren12388743ch_irren
chlordan1445493chlordan
choreman15117603choreman
chrisma1456823chrisma_
chrismal1575173chrismal
chrismon1544643chrismon
claimant1247483clai_mant
clansman1245813clansman
coachman1744983coachman
cochairmen1951933cochairmen
colorman1247893colorman
cragsman1345213cragsman
dairyman1443493_dairyman
dharma1276103dha_rma_
dharmas1356513dha_rmas
firman112211343__firman
hackman1836433_hackman
hairband1444573_hairband
haircap14134753_haircap
hairpin1245413_hairpin
hangman1337813_hangman
hanuman1237133_hanuman
harijan1735783_harijan
harmin113117393_ha_rmin
hitman112710223_h_itman
mailman1137733_mailman
repairman1342313repairman
shairn9269063shair__n
shaitan1036893shai_tan
shaman113314283sha__man
shipman14247133sh_ipman
thairm1156963thairm__
thairms1244453thairm_s
trainman1046233trainman
whaleman1643973whaleman

Search took 7 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.423422437.4
2DLD Change Limit146162966.45322650.2
3Display Results96960.0462087.0
 (SQL Overall)178691966.92225814.9
 
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.