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

170 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
sidemen103794(None) 
sideman1037971sideman
aidmen92610372aid_men
bedemen12910182bedemen
firemen1238772firemen
icemen1037892_icemen
linemen938632linemen
pikemen1535332pikemen
seedmen1037682seedmen
semen75724102s__emen
siemens938412si_emens
sokemen1337052sokemen
wiremen1236902wiremen
abdomen1237023abdomen
admen84516183_ad_men
aidman92410623aid_man
airmen82612353ai_rmen
aldermen1145043aldermen
axemen1547493_axemen
badmen114613833bad_men
basemen1139083basemen
bedeman12168843bedeman
bedesmen1355713bedesmen
bidden104010793bid_den
birdmen1235833birdmen
bireme10310143bireme_
biremes1138773biremes
bitumen1134503bitumen
bodement13410123bodement
cavemen1437143cavemen
deme76536283__deme_
demean9510563__demean
dement93825143__dement
demes86032693__demes
demon86520313__demon
diademed1344153diademed
dudeen857173dude_en
eudemon1064753eudemon
fireman1249333fireman
foemen11310523_foemen
foremen12412923foremen
freemen1238463freemen
gatemen1047603gatemen
gleemen1035723gleemen
hidden11429743hid_den
hitmen11239193hi_tmen
iceman1037853_iceman
idem76121063_idem__
itemed936603_itemed
kinsmen1335653kinsmen
kirkmen1232923kirkmen
liegemen1144133liegemen
liftmen1234233liftmen
limen75426033li__men
lineman939113lineman
linesmen1046563linesmen
linkmen1335363linkmen
madmen113511743mad_men
midden104112853mid_den
middlemen1542733middlemen
milkmen1565213milkmen
modemed1336723modemed
oilmen848313oi_lmen
pikeman1535523pikeman
pitmen102510793pi_tmen
premen105017803_premen
reedmen1038333reedmen
ridden83511723rid_den
riflemen1344243riflemen
rodmen939713rod_men
rodsmen1035833rodsmen
sadden83212403sad_den
sagamen10127503sagamen
salesmen1047243salesmen
sandmen1039413sandmen
sateen63815013sate_en
scheme1379633scheme_
schemed1577753schemed
schemer1477953schemer
schemes1489663schemes
screen85216013scre_en
seamen84518563s_eamen
sediment11411103sediment
seedman1037373seedman
seedsmen1144303seedsmen
seemed95117613s_eemed
seemer84418043s_eemer
seen46943123s__e_en
seme65836653s__eme_
sememe10129983sememe_
sememes11109203sememes
semens84616963s__emens
semes75731583s__emes
seven84118313s__even
sheen85023313s_he_en
sheepmen1544643sheepmen
shipmen14317283shipmen
shopmen14277193shopmen
showmen15227163showmen
sicken124615253si_cken
side55444483sid__e_
sidearm1035963sidearm
sideband1245023sideband
sidebar1045563sidebar
sidecar1045233sidecar
sided74825953sid__ed
sideline91011093sideline
sideling101012173sideling
sidelong10133983sidelong
sidereal946053sidereal
sides65838363sid__es
sidespin1143943sidespin
sidestep1144243sidestep
sideway1445673sideway
sidhe95315103sid_he_
sidle65124033sid_le_
sidled84215173sid_led
sidler74716963sid_ler
sidles74721153sid_les
siege66718443si_ege_
sieged85212713si_eged
sieges73816833si_eges
sieve84918843si_eve_
sieved104611443si_eved
sieves93216003si_eves
silexes1438653silexes
silken104410853si_lken
simmer104115353si_mmer
sinewed1137053sinewed
siree55238813sire_e_
sirees64624583sire_es
siren54525823si__ren
sitten64113823si_tten
sixteen1434113sixteen
skeen94817403s_ke_en
skymen1535313s_kymen
sleeken11326803sleeken
slidden935153slid_den
smidgen11426513smid_gen
snowmen12246153snowmen
sockmen1535453sockmen
socmen1039193s_ocmen
sodden84011513sod_den
sokeman1337263sokeman
solemn838643solem_n
spacemen1445413spacemen
spireme11478363spireme_
spiremes12397623spiremes
spleen8310263sple_en
stamen84115943s_tamen
steepen9348653steepen
stickmen1634543stickmen
stillmen1044123stillmen
sudden83310833sud_den
supermen12311303supermen
surfmen1235993surfmen
swagmen1334973swagmen
sweeten10267313sweeten
sweven1235983s_weven
swidden1234233swid_den
swingmen1443483swingmen
telemen9310173telemen
tinmen82310393ti_nmen
titmen8239883ti_tmen
vimen104114753vi__men
widen94717973wid__en
widened12328053widened
widener11318693widener
wingmen1336103wingmen
wireman1237843wireman

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.1561145455.1
2DLD Change Limit1340271707.75017293.8
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.96922423.3
 
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.