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

417 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
siemens93841(None) 
semens84616961s_emens
limens84618032li_mens
seemers93814332seemers
semen75724102s_emen_
semes75731582s_eme_s
sevens93813662s_evens
sheens95116992she_ens
sickens134411482sickens
sidemen1037942sidemen_
sieges73816832siege_s
sieves93216002sieve_s
simmers113314612simmers
sirens65318152si_rens
sithens1039382sithens
skeens103912912ske_ens
stamens93411482stamens
swevens1334612swevens
acumens1136953acumens
aidmen92610373aidmen_
ailment9314233ailment
ailments1039433ailments
aimers84621913ai_mers
airmen82612353airmen_
amens75624843__amens
axemen1547493axemen_
bemeans1148733_bemeans
biogens1038963biogens
biomes103815253biome_s
biremes1138773bireme_s
bitumens1243523bitumens
cement103321663_cement
cements112714223_cements
clement11313773clement
cremes104517993creme_s
daemons10269233daemons
deepens10307813deepens
demeans1039713_demeans
dement93825143_dement
dements103016623_dements
demes86032693_deme_s
demons94917723_demons
diamins10312203diamins
dickens144410133dickens
dienes75719903diene_s
diesels8429143diesels
dieses75218693diese_s
dieters83216423dieters
dimers94321093di_mers
dimes85833043di_me_s
dimmers123811563dimmers
dismes95617673disme_s
dizens164911393di_zens
dolmens10388693dolmens
element9317803element
elements10312173elements
elevens1066803elevens
emend86214893__emend
emends95711433__emends
emes65434663__eme_s
emeus76913333__emeus
evens84817103__evens
examens1637193examens
femes105626223_feme_s
figment1379743figment
figments1446943figments
filmers124211293filmers
firemen1238773firemen_
firmans12238523firmans
firmers124711443firmers
fitment12710303fitment
fitments1376793fitments
flamens124611063flamens
flehmens1643233flehmens
foemen11310523foemen_
germens1078623germens
gimels938893gi_mels
gimmes113010903gimme_s
givens10379733gi_vens
greens75716873gre_ens
haemins122811393haemins
hemes105031083_heme_s
hemins113417563_hemins
hitmen11239193hitmen_
hymens1437993_hymens
icemen1037893icemen_
immense1135293_immense
isomers9310043isomers
keens95721183_ke_ens
kirmess13234313kirmess
kismets13306883kismets
kittens11347583kittens
lebens8310093_lebens
lemans85316393_lemans
lemons84415053_lemons
lichens123510683lichens
lieges74113443liege_s
liens56525503li__ens
liernes739623liernes
likens105613703li_kens
limans84816303li_mans
limen75426033li_men_
limes75636503li_me_s
limeys11429273li_meys
limmers113413083limmers
limns75718393li_m_ns
lindens839413lindens
linemen938633linemen_
linens64818393li_nens
lippens11328533lippens
listens74014133listens
livens94314893li_vens
lumens85013973_lumens
memes94927703_meme_s
middens11379373middens
miens76118303mi__ens
mildens10339933mildens
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mispens11311073mispens
mittens9349883mittens
mizens174610253mi_zens
mizzens17366123mizzens
nieces84112713niece_s
nieves94311293nieve_s
oilmen848313oilmen_
omens75618963__omens
peens76428193_pe_ens
piecers114112253piecers
pieces104217273piece_s
pigment12510733pigment
pigments1337343pigments
pigpens1235503pigpens
pikemen1535333pikemen_
pinkens13419643pinkens
pitmans11188743pitmans
pitmen102510793pitmen_
preens85020113pre_ens
premeds12389583premeds
premen105017803premen_
queens15338873que_ens
quietens17246343quietens
remans84823003_remans
remend95216553_remend
remends105013033_remends
rhemes115913183rheme_s
richens12349733richens
rievers104311453rievers
rimers84522553ri_mers
rimes75634543ri_me_s
rimmers113812883rimmers
ripens85012173ri_pens
rumens83611813_rumens
saddens9309603saddens
saimins9312113saimins
salmons93713253salmons
sameks12409323s_ameks
sapiens9310173sapiens
sarment9318763sarment
sarments10311963sarments
sarsens7311393sarsens
sateens73710753sateens
scenes84520353scene_s
schemers1576703schemers
schemes1489663scheme_s
screens95212173screens
seamen84518563seamen_
seamers94719433seamers
secerns987733s_ecerns
sedans74816093s_edans
seders74420283s_eders
seeders83017113seeders
seedmen1037683seedmen_
seeds64330063s_e_eds
seekers113712333seekers
seeks94724643s_e_eks
seels55632823s_e_els
seemed95117613seeme_d
seemer84418043seeme_r
seeming103216263seeming
seemings11337633seemings
seems75525023s_e_ems
seen46943123s_e_en_
seeps74828753s_e_eps
seeress7311573seeress
seers55136383s_e_ers
sees45361053s_e_e_s
segment10312563segment
segments1138903segments
seidels838393seidels
seiners74219273seiners
seines65029903seine_s
seisers73816393seisers
seises64026713seise_s
seisins73614393seisins
seitans73312303seitans
seizers164112503seizers
seizes154317533seize_s
seizins164010133seizins
seme65836653s_eme__
sememe10129983s_ememe
sememes11109203s_ememes
semina8915563s_emina
semis74623533s_em_is
sereins73716113s_ereins
serene63522353s_erene
serenes73222903s_erenes
seres55448893s_ere_s
serins64029673s_erins
sermons9311783sermons
setons64620173s_etons
seven84118313s_even_
severs94121123s_evers
sewans95215903s_ewans
sewers94719713s_ewers
sexes126126223s_exe_s
shamans123610893shamans
shames114726223shame_s
shebeans1344703shebeans
shebeens1343333shebeens
sheen85023313she_en_
sheeny124912193she_eny
sheers94322403she_ers
sheets93918493she_ets
shekels1436043shekels
sheqels1934753sheqels
shewers134312043shewers
shimmers15269413shimmers
shipmen14317283shipmen_
shipment15217593shipment
shipments16254703shipments
shippens15316793shippens
siamang1045313siamang
siamangs1144053siamangs
siamese936503siamese
siameses1036403siameses
sices75637273si_ce_s
sickees134514213sickees
sicken124615253sicken_
sideman1037973sideman_
sides65838363si_de_s
sidlers83414223sidlers
sidles74721153sidle_s
siege66718443siege__
sieged85212713siege_d
sieging92613203sieging
sienna647193sie_nna
siennas736123siennas
sierras737863sierras
siestas738813siestas
sieurs659043sie_urs
sieve84918843sieve__
sieved104611443sieve_d
sievert10613293sievert
sieverts1145713sieverts
sieving112311233sieving
sifters103714783sifters
sighers113712173sighers
sigmas94111353sigm_as
signees83510803signees
signers84714423signers
signets83311503signets
signs65516323si__gns
sikes96236083si_ke_s
silanes72517163silanes
sileni63312143si_leni
silent64125843si_lent
silents73514493si_lents
silenus7369693si_lenus
silexes1438653silexe_s
silken104410853silken_
sillers73822093sillers
silvans10308323silvans
silvers104714033silvers
simars84916933si_mars
simas75727553si_m_as
simians959203simians
simlins9311823simlins
simmer104115353simme_r
simnel857023si_mnel
simnels976103simnels
simony1137903si_mony
simoons937933simoons
simpers113014113simpers
simps94719763si_m_ps
sims65737173si_m__s
sines55954823si_ne_s
sinews94210623si_news
singers83824693singers
singes74326853singe_s
sinkers113618543sinkers
sinless73014213sinless
sinners74019013sinners
sins46755273si___ns
sinters74024073sinters
sipes76036953si_pe_s
siphons1239343siphons
sippers113117743sippers
sippets113310173sippets
sirees64624583si_rees
siren54525823si_ren_
sires55945373si_re_s
sirrees73410563sirrees
sises55233833si_se_s
siskins1159583siskins
sisses64520603sisse_s
sisters73721573sisters
sites56045433si_te_s
sitten64113823sitten_
sitters74221543sitters
sivers95324153si_vers
sixes124526363si_xe_s
sixmos1534813sixm_os
sixteens1542943sixteens
sixtes133612403sixte_s
sizers155215813si_zers
sizes146727763si_ze_s
skeanes113610713skeanes
skeans104512913ske_ans
skeen94817403ske_en_
skees95023123ske_e_s
skeets104513253ske_ets
skeins103911903ske_ins
skenes104616633skene_s
skewers14498373skewers
skimmers16296453skimmers
skymen1535313skymen_
sleekens12274873sleekens
sleeks104512463sle_eks
sleeps83913323sle_eps
sleets64318873sle_ets
slickens14317263slickens
slieves10378963slieve_s
slimes84722043slime_s
slimmers12369633slimmers
slovens10316573slovens
smeeks12428433sme_eks
smews104612293s__mews
smidgens12325643smidgens
sneers64016173sne_ers
socmen1039193socmen_
soddens9348413soddens
softens10347623softens
sokemen1337053sokemen_
somans84619303s_omans
sowens93613153s_owens
speans85417143spe_ans
specimens1543403specimens
speeds94316053spe_eds
speels85116393spe_els
speers85019953spe_ers
spewers124210653spewers
spiegels1133873spiegels
spielers10319643spielers
spiremes12397623spireme_s
spleens937103spleens
spumes1021314883spume_s
stamen84115943stamen_
steamers103410873steamers
steeds73814883ste_eds
steeks103613703ste_eks
steels64117983ste_els
steepens10277113steepens
steeps85215193ste_eps
steers63820983ste_ers
steins64818343ste_ins
stelene7310253stelene
steles63725663stele_s
stemless1036653stemless
stemmas11256973stemmas
stemmers12378443stemmers
stems75219953stem__s
stemsons1044993stemsons
stereos74314973stereos
steres63929533stere_s
sterns64616753ste_rns
stiffens14244103stiffens
stimes85920573stime_s
submenu1148363submenu
submenus1245903submenus
suddens9308783suddens
suedes73918113suede_s
summers113616503summers
summons1158003summons
swedes102711893swede_s
sweeny12358843swe_eny
sweeps114110513swe_eps
sweetens11255433sweetens
sweets94214433swe_ets
sweven1235983sweven_
swiddens1342713swiddens
swimmers15276693swimmers
syrens94911993s_yrens
teemers95012903teemers
teens56227483_te_ens
themes115319253theme_s
tieless72512563tieless
tiepins939463tiepins
timers84420993ti_mers
times75630823ti_me_s
tinmen82310393tinmen_
titmen8239883titmen_
treens65317873tre_ens
tsimmes1133673tsimme_s
tweens9489843twe_ens
viewers1337173viewers
vimen104114753vi_men_
vixens16286203vi_xens
weens85224053_we_ens
wheens124610613whe_ens
widens106212723wi_dens
wieners103212483wieners
wiremen1236903wiremen_
wizens186110263wi_zens
wizzens18385483wizzens
yamens114010823_yamens

Search took 9 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 Limit1340274177.73317331.8
3Display Results4174170.1562673.1
 (SQL Overall)1786914178.04522211.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.