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

129 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
clubmen133425(None) 
clubman1344021clubman
albumen1135242albumen
cabmen123610652c_abmen
clubbed14307452clubbed
clubber13319592clubber
clubwomen1852122clubwomen
clumber134011442clumber
lumen75220902_lu_men
acumen1049013acu_men
albumens1244143albumens
albumin1145563albumin
almsmen1144583almsmen
alumin8513543alu_min
blubbed11338393blubbed
blubber10399293blubber
bluesmen1244153bluesmen
blume95619893blu_me_
blumed114313643blu_med
blumes105917793blu_mes
busmen1039893_busmen
cabman123812503c_abman
calumet11313293calu_met
carmen104019343c_armen
cavemen1437143cavemen
cerumen1147763cerumen
chapmen1637283chapmen
chummed17396443chummed
clabber134210113clabber
claimed12298833claimed
claimer11279883claimer
clamber133311733clamber
clammed14369963clammed
clammer134211793clammer
clansmen1245723clansmen
clement11313773cl_ement
cleome1039083cleome_
cleomes1138813cleomes
climbed14336983climbed
climber13449133climber
clime95720893cl_ime_
climes104720003cl_imes
clobber13378163clobber
cloven114211513cl_oven
club85819473club___
clubbers14378573clubbers
clubbier1434833clubbier
clubbing15266513clubbing
clubby1534683club_by
clubfeet1543793clubfeet
clubhand1642433clubhand
clubhead1662773clubhead
clubs95415103club__s
clubwoman1852253clubwoman
clucked163810133clucked
clue65324533clu__e_
clued84917683clu__ed
clues74623033clu__es
clumbers143910393clumbers
clump115517453clu_m_p
clumped143610663clumped
clumps1215314643clu_mps
clumpy15409573clu_mpy
clumsy13326193clu_msy
clunked14439573clunked
clunker13419453clunker
cluster94013323cluster
clutter94211653clutter
colormen1247243colormen
columel1136273colu_mel
column1038103colu_m_n
cowmen13810923c_owmen
crewmen1436373crewmen
crumbed14378473crumbed
crumber13339643crumber
cube85830213c_ub_e_
cubeb115814653c_ub_eb
cubed105519703c_ub_ed
cuber95222533c_ub_er
cubes95028163c_ub_es
culmed114610593c_ulmed
cumber124016703c_umber
cumin94616973c_u_min
cummer124414593c_ummer
cummin1288783c_ummin
flagmen13226913flagmen
flamen115215993fl_amen
flehmen1534913flehmen
flubbed15306633flubbed
flubber14287713flubber
flume106021173flu_me_
flumed124915263flu_med
flumes115119733flu_mes
flymen14387773fl_ymen
gleemen1035723gleemen
glume85120463glu_me_
glumes94516813glu_mes
glummer12417983glummer
gluten74210753glu_ten
gunmen9348723_gunmen
lawmen11308593_lawmen
laymen113010843_laymen
leben7314853_leb_en
legmen939343_legmen
limen75426033_l_imen
lubber104214623_lubber
lube64731563_lub_e_
lubed85319893_lub_ed
lubes74727993_lub_es
lumber103817773_lumber
lumens85013973_lu_mens
lumpen104010663_lumpen
numen74216793_nu_men
plowmen1434883plowmen
plumbed14317273plumbed
plumber13339983plumber
plume94819463plu_me_
plumed114412883plu_med
plumes104318133plu_mes
plummer13298523plummer
plummet13278353plummet
plumpen13276403plumpen
rumen74419503_ru_men
slubbed12339283slubbed
slubber113010763slubber
slumber113811003slumber
slummed12359273slummed
slummer113711203slummer
submenu1148363_submenu

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 Filter1786911340270.220812231.8
2DLD Change Limit1340271296.81319672.2
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.07925242.4
 
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.