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

269 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
newsie913821(None) 
newbie11135411newbie
newie81813481new_ie
newsier10147221newsier
newsies101310381newsies
gawsie1038462gawsie
kewpie15465412kewpie
nellie63614812nellie
newbies12147422newbies
newies91014072new_ies
newish1237902newish
news76127372news__
newsiest11107482newsiest
newsmen1235892newsmen
newswire1442602newswire
newsy11489392news_y
nowise9511072nowise
aerie54634603ae_rie
anywise1345203anywise
bawtie113812143bawtie
beanie83618593beanie
beastie92412433beastie
bedside1156843bedside
bedsit9312843bedsit
belie75630383be_lie
beside95114613be_side
betise85616273betise
bewail1189583bewail
beware11313713beware
bewig1138903bew_ig
bowse105420633bows_e
cease75227653ceas_e
cense75121403cens_e
cerise84822043cerise
cosie74728263_cosie
cowpie133511513cowpie
cowrie113814283cowrie
dassie74615573dassie
dawtie103011093dawtie
dearie73319813dearie
deasil71110983deasil
demise94618323demise
dense65923503dens_e
depside1138403depside
desire7415303de_sire
devise104215753devise
dewier104013463dew_ier
dews86230603dews__
dexie134716893de_xie
donsie7613643donsie
dowie94721143dow_ie
dowse96020813dows_e
ease45042333_eas_e
easier64218463_easier
easies64126633_easies
eerie55228533_eerie
else45923083_els_e
endwise1136463endwise
enisle63412093enisle
enosis63816423enosis
ensile62616473_ensile
ensue54013833_ensue
eosin55220923_eosin
eosine64519413_eosine
esne47018793_e_sne
ewe66630983_ew__e
eyrie88117833_eyrie
falsie93513853falsie
fease84824873feas_e
feirie939553feirie
felsic1147053felsic
felsite1039083felsite
ferlie92814053ferlie
fesse86116333fe_sse
geese64316003gees_e
genie66124923ge_nie
geste65920693ge_ste
gussie72910153gussie
hawkie163810093hawkie
hawse116015123haws_e
heinie92512663heinie
hempie132410563hempie
hessite1038993hessite
hews105631573hews__
howdie13349733howdie
jesse126012833je_sse
jews145822083jews__
kebbie1435813kebbie
kelpie12308613kelpie
kewpies16246923kewpies
kneesies1245543kneesies
lassie64917743lassie
lease55230263leas_e
lense54523433lens_e
lessee64116363lessee
lewis85315843lew_is
lewises1039133lewises
lewisite1154543lewisite
lezzie1435333lezzie
lowse87219903lows_e
mealie82519813mealie
meanie83718393meanie
measle83513223measle
meinie82614523meinie
mensae84114043mensae
mense75025633mens_e
mesic93617863me_sic
mesne75116293me_sne
messier93412923messier
mews96629333mews__
nannie63713223nannie
nappie104112263nappie
nearside944913nearside
nebs66124983nebs__
nebule848753nebule
necktie1344363necktie
neddies92710703neddies
nee36657783ne___e
needier84010623needier
needle73310613needle
negate72915573negate
neglige934873neglige
negs55727363negs__
neif75429493ne__if
neist54628443neis_t
nellies73418723nellies
nelson638423nelson
nemesis937373nemesis
nene45932063ne__ne
nerdier83110353nerdier
nereid7312923nereid
nereis6315343nereis
nerve86617373ne_rve
nervier10298833nervier
nervine102510623nervine
ness45526563ne_s_s
nesses64718323nesses
nest45548733ne_s_t
nested74720063ne_sted
nester64124183ne_ster
nestle63013953nestle
nests55728003ne_sts
netlike11308913netlike
nets45941533nets__
netsuke1142673netsuke
nettier74211813nettier
nettle64514583nettle
neume74414403ne_ume
neumic1036853neumic
neurine7311683neurine
neustic937943neustic
neve76224833ne__ve
nevi75116423ne_vi_
nevoid1098793nevoid
new66237093new___
newel86114133new_el
newels93710823newels
newer85717463new_er
newest9314213newest
newly114610203new_ly
newsbeat1343623newsbeat
newsboy1542493newsboy
newsdesk1641733newsdesk
newsgirl1251823newsgirl
newsiness1236033newsiness
newsless1134533newsless
newsman1245503newsman
newspeak1742563newspeak
newsreel1142863newsreel
newswires1542613newswires
newt76933743new__t
newton936983newton
newts86015283new_ts
ngwee9311073ngw_ee
nisei54214353n_isei
nisi45823243n_isi_
nixie125114943n_ixie
noesis6311443noesis
noise55723733nois_e
noisier759453noisier
noogie73612313noogie
nookie103712433nookie
noose55624063noos_e
nose46739363n_os_e
nosier63716323n_osier
nows75738233nows__
nudie65118673n_udie
nurse54420123nurs_e
nutsier7329253nutsier
owse76321623_ows_e
pease75231113peas_e
peerie83617893peerie
peise75825773peis_e
pensee8417313pensee
pensil83013333pensil
pensile92713543pensile
pensive122610393pensive
pepsin10310853pepsin
pepsine11310603pepsine
perdie94718513perdie
perse75429523pers_e
pewee10319973pew_ee
pewit104622793pew_it
pews95731533pews__
popsie103013053popsie
potsie83916033potsie
remise84221953remise
rerise64325633rerise
resee54336333re_see
resid64124093re_sid
reside74224933re_side
resile64627673re_sile
resin54131053re_sin
resit54241043re_sit
resite64128453re_site
resize154117723re_size
retie55735303re_tie
reuse56025363reus_e
revise94019743revise
rewake135218463rewake
rewin85623963rew_in
rewire95421403rewire
rewoke1339521213rewoke
rewore938030153rewore
rewove126420073rewove
rewrite10311143rewrite
seaside839693seaside
seise54727853seis_e
seisin63715123seisin
selkie102811693selkie
sense55526823sens_e
sensei64712593sensei
sepsis83011293sepsis
sessile739523sessile
sewage10310733sewage
sews75836023sews__
sonsie6614863sonsie
tassie66017023tassie
tawie84819813taw_ie
tawpie11339143tawpie
tawse85616503taws_e
tease55428713teas_e
techie11511723techie
tekkie934203tekkie
tense55225843tens_e
tensile72612733tensile
tensive10269913tensive
tentie62521183tentie
terse55026823ters_e
tews76431643tews__
towie85821873tow_ie
townie93312303townie
unease63816643uneas_e
uneasier836963uneasier
unwise9510803unwise
veggie1136303veggie
vegie94614513ve_gie
verse84723583vers_e
versine102515173versine
verste94515633verste
website1235323website
wedgie11428353wedgie
weenie92612023weenie
weepie11258793weepie
wellie92814913wellie
wise75737343__wise
yews105323963yews__
yowie114616453yow_ie
zowie174313843zow_ie

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162695.78319490.9
3Display Results2692690.0932892.5
 (SQL Overall)1786912695.99929786.8
 
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.