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

153 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
sideman103797(None) 
sidemen1037941sidemen
aidman92410622aid_man
bedeman12168842bedeman
fireman1249332fireman
iceman1037852_iceman
lineman939122lineman
pikeman1535522pikeman
seedman1037372seedman
sideband1245022sideband
sidebar1045562sidebar
sidecar1045232sidecar
sideway1445672sideway
sokeman1337262sokeman
wireman1237842wireman
adman84517903_ad_man
aidmen92610373aid_men
airman82414223ai_rman
alderman1145193alderman
axeman1538103_axeman
badman113813843bad_man
baseman1138553baseman
bedemen12910183bedemen
bedesman1345083bedesman
birdman1236673birdman
caveman1437073caveman
cinema1047653cinema_
cinemas1138043cinemas
daman84821163__daman
dean56039483__de_an
demand104314253__demand
demean9510563__demean
demon86520313__demon
desman9311693__desman
dewan95718043__dewan
edema8610553_edema_
edemas9310503_edemas
eudemon1064753eudemon
firemen1238773firemen
firepan1236983firepan
firman112211343fi_rman
foeman11311233_foeman
foreman12312363foreman
freeman1237343freeman
gateman1057473gateman
gleeman1035363gleeman
hiemal11339503hi_emal
hitman112710223hi_tman
icemen1037893_icemen
idea59122773_ide_a_
ideal65716393_ide_al
ideas65919013_ide_as
idem76121063_idem__
kinema1236023kinema_
kinemas1336893kinemas
kinsman1335963kinsman
kirkman1243773kirkman
leman75622603__leman
liegeman1143343liegeman
liftman1244063liftman
liman75921603li__man
linemen938633linemen
linesman1046253linesman
linkman1335393linkman
madman113712383mad_man
middleman1542053middleman
milkman1544913milkman
oedema936573oedema_
oedemas1056693oedemas
oilman839483oi_lman
pikemen1535333pikemen
pitman102412123pi_tman
preman104117453_preman
redemand1245923redemand
reedman1037723reedman
reman75730153__reman
rifleman1343413rifleman
rodman949713rod_man
rodsman1036653rodsman
sagaman10117563sagaman
salesman1047353salesman
sandman10310173sandman
schema1388373schema_
schemas1468163schemas
seaman84015903s_eaman
sedan65620423s__edan
seedmen1037683seedmen
seedsman1144893seedsman
semen75724103s__emen
sewan85921293s__ewan
shaman113314283s_haman
sheepman1543853sheepman
shipman14247133shipman
shopman14247263shopman
showman15257293showman
siamang1045333si_amang
siccan1037593si_ccan
side55444493side___
sidearm1035973sidearm
sidebands1344443sidebands
sidebars1146643sidebars
sidecars1145903sidecars
sided74825953side__d
sideline91011093sideline
sideling101012183sideling
sidelong10133983sidelong
sidereal946053sidereal
sides65838363side__s
sidespin1143943sidespin
sidewalk1644093sidewalk
sidewall1244803sidewall
sideward1345953sideward
sideways1545233sideways
siemens938413si_emens
sienna647193si_enna
sierran737193sierran
sigma84513833si_gma_
sigmas94111363si_gmas
silvan92810153si_lvan
sima64730783si__ma_
simar74920813si__mar
simas75727553si__mas
simian8811163si_mian
siren54525823sire__n
sirenian845783sirenian
skean94415623s_ke_an
skyman1535313s_kyman
slideway1543163slideway
snowman12226623snowman
sockman1535663sockman
socman1039813s_ocman
sokemen1337053sokemen
solemn838643solem_n
soman75024903s__oman
spaceman1445323spaceman
spean74620513s_pe_an
stickman1643943stickman
stillman1043953stillman
subdean1037403subde_an
superman12310233superman
surfman1236203surfman
swagman1334913swagman
swingman1443593swingman
teleman959573teleman
tideland1044633tideland
tidemark1543403tidemark
tideway1445153tideway
tinman82411143ti_nman
titman82711003ti_tman
wideband1544453wideband
widen94717973wide__n
wingman1336383wingman
wiremen1236903wiremen

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.390458182.1
2DLD Change Limit1340271537.20318607.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.63923391.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.