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

137 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
showman1525729(None) 
shopman14247261shopman
showmen15227171showmen
snowman12226621snowman
bowman13129852_bowman
cowman13910372_cowman
plowman1444932plowman
shaman113314282sh_aman
shipman14247132shipman
shopmen14277202shopmen
shoran94016042sho_ran
showmanly2041902showmanly
shown115216482show__n
snowmen12246152snowmen
socman1039812s_ocman
soman75024902s_o_man
adwoman1345433adwoman
ajowan1634893ajow_an
ashman1148383ash__man
bookman15136483bookman
bowmen1399853_bowmen
chapman1637893chapman
choreman15117603choreman
cowmen13810923_cowmen
crewman1435753crewman
dolman95312403_dolman
doorman1037063doorman
foeman11311233_foeman
footman1236403footman
frogman1335873frogman
goodman1135933goodman
gowan95415743_gow_an
hetman112510603_hetman
hitman112710223_hitman
hogan97817703_ho_gan
hogmane1336343_hogmane
honan85319773_ho_nan
howdah1634723_howdah
human102716033_h_uman
hwan105716893_h_w_an
ironman936613ironman
lawman11289053_lawman
nonman8412363_nonman
plowmen1434883plowmen
potman102813573_potman
propman1339063propman
rodman949713_rodman
roman75424823_ro_man
rowan85418733_row_an
sagaman10117563sagaman
sandman10310173sandman
schoolman1642993schoolman
seaman84015903s_eaman
seawan94111223seaw_an
seedman1037373seedman
sewan85921293s_ew_an
shaitan1036893shaitan
shamans123610903sh_amans
shamas113717943sh_amas
shammas14358723shammas
shawm135316153shawm__
shawms14579563shawm_s
shawn116417613shaw__n
shebean1235763shebean
sheepman1543853sheepman
sheitan1036573sheitan
shewn115715703shew__n
shipmen14317283shipmen
shoal83920273sho__al
shoat85633953sho__at
shodden12265763shodden
shoepac1444013shoepac
shofar1236313sho_far
shogun1045713sho_gun
shoon84022013sho__on
shophar1555463shophar
shopworn1643983shopworn
shorans102812413sho_rans
shorn85722183sho__rn
shorten103511413shorten
shotgun1143003shotgun
shotten10288463shotten
show106229193show___
showbiz2453223showbiz
showboat1645393showboat
showcase1643123showcase
showdown1843573showdown
showed135016973show_ed
shower124315113show_er
showers134612683showers
showery16437243showery
showier1339103showier
showily1636223showily
showing143814663showing
showoff1943893showoff
showring1548323showring
shows115324583show__s
showy145714013show__y
shwa106014963sh_w_a_
shwas116415103sh_w_as
sideman1037973sideman
skyman1535313s_kyman
slogan7539223slo_gan
snowbank1743233snowbank
snowcap1442823snowcap
snowcat1245333snowcat
snowland1243833snowland
sockman1535663sockman
socmen1039193s_ocmen
sokeman1337263sokeman
solan55328153s_o_lan
soldan73511853s_oldan
soma65635293s_o_ma_
somans84619303s_o_mans
somas76030373s_o_mas
soudan73210353s_oudan
sovran937153s_ovran
sowans94215893s_ow_ans
sowar85821343s_ow_ar
sowcar1135863s_owcar
sown75127453s_ow__n
sporran936743sporran
stewpan1234193stewpan
stockman1644143stockman
stoma75918273sto_ma_
stomal85213313sto_mal
stomas84816323sto_mas
surfman1236203surfman
swagman1334913swagman
swan76631313s__w_an
swordman1443403swordman
toman75724053_to_man
washwoman2082623washwoman
woman105818003_wo_man
woodman1336313woodman
woolman1235433woolman
yeoman1138823yeo_man

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.453394461.4
2DLD Change Limit1340271376.97019229.1
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.46923924.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.