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

294 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
newsier1014722(None) 
newsie9138211newsie_
newsies101310381newsies
dewier104013462dew_ier
easier64218462_easier
messier93412922messier
needier84010622needier
nerdier83110352nerdier
nervier10298832nervier
nester64124182ne_ster
nettier74211812nettier
newbie11135412newbie_
newbies12147422newbies
newer85717462new__er
newie81813482new_ie_
newies91014072new_ies
newsiest11107482newsiest
newsmen1235892newsmen
newswire1442602newswire
noisier759452noisier
nosier63716322n_osier
nutsier7329252nutsier
uneasier836962uneasier
aerier64823153ae_rier
antsier7410773antsier
artsier768943artsier
bawdier13378203bawdier
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
beefier12329093beefier
beerier93613023beerier
belier84423563be_lier
bendier103111413bendier
bewailer1334863bewailer
bitsier9379073bitsier
blowsier1335063blowsier
bossier93712423bossier
brasier94516753brasier
busier85219723_busier
censer84516583cens_er
cheesier1335963cheesier
chewier1537583chew_ier
cosier84423753_cosier
cowier113616163cow_ier
creasier103210193creasier
crosier94116573crosier
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
denser74115193dens_er
dernier83011943dernier
desire7415303de_sire
desirer8310783de_sirer
deviser114212393deviser
dewater112912423dewater
ditsier83010293ditsier
dossier83711693dossier
dowdier12328573dowdier
downier11299703downier
dowser104716083dows_er
dressier956863dressier
drowsier1284903drowsier
easies64126633_easies
easter65027983_easter
edgier8469723_edgier
eelier64216463_eelier
eerier64320023_eerier
elmier839813_elmier
envier939673_envier
esker94412983_e_sker
ester54727713_e_ster
ewer77523983_ew__er
fawnier13296363fawnier
feaster10812983feaster
feistier1136193feistier
fennier10339253fennier
fernier103110813fernier
fester94723513fe_ster
fewer115216123few__er
frowsier1444893frowsier
fubsier12367763fubsier
fussier103610673fussier
gassier83812573gassier
gawkier15326523gawkier
gawsie1038463gawsie_
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
geyser1036513geys_er
goosier83512563goosier
gorsier83811073gorsier
greasier9298083greasier
gutsier8389823gutsier
hawser125910843haws_er
headier113212953headier
heavier13429423heavier
hedgier12367873hedgier
heftier1337203heftier
heister103613623heister
hempier14319003hempier
herbier1239593herbier
hewer115719933hew__er
hissier103410503hissier
horsier103013243horsier
hosier94219613_hosier
jerkier18407273jerkier
jester134319153je_ster
jettier14358693jettier
jeweler1735053jeweler
jowlier17327563jowlier
keester11319913keester
keister113011573keister
kewpie15465413kewpie_
kewpies16246923kewpies
keyster14256153keyster
kneesies1245543kneesies
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
learier73415663learier
leaser65322673leas_er
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
leister73212753leister
lesser63514853le_sser
levier94013873le_vier
lewder10479613lew_der
lewises1039133lewises
lousier72411623lousier
lowlier10338903lowlier
massier93615223massier
mealier93015903mealier
measlier1036013measlier
meatier93214613meatier
meister93114163meister
merrier92612303merrier
meshier123410853meshier
metier83517693me_tier
mewler113510233mew_ler
mossier94413813mossier
mousier93712463mousier
mussier93314353mussier
naggier9309153naggier
nappier114411173nappier
nastier74115293nastier
nattier73614623nattier
nearer64618893ne_arer
nearlier836793nearlier
neater64424313ne_ater
necker124012793ne_cker
neddies92710703neddies
needer73614953ne_eder
needler8388893needler
negater83711953negater
neither1037573neither
nellie63614813nellie_
nellies73418723nellies
nesses64718323ne_sses
nested74720063ne_sted
nesters74422783ne_sters
nestler73510443nestler
nestor63713413ne_stor
nether94014163ne_ther
netter63722023ne_tter
nettler7349503nettler
nettlier864813nettlier
neuter63713793ne_uter
never86218643ne__ver
newcomer1543343newcomer
newel86114133new__el
newish1237903new_ish
news76127373news___
newsbeat1343623newsbeat
newsboy1542493newsboy
newsdesk1641733newsdesk
newsgirl1251823newsgirl
newsiness1236033newsiness
newsless1134533newsless
newsmaker1843423newsmaker
newsman1245503newsman
newspaper1642973newspaper
newspeak1742563newspeak
newsreel1142863newsreel
newswires1542603newswires
newsy11489393news__y
newwaver1741963newwaver
niftier10328713niftier
nippier11319833nippier
nittier73512243nittier
nobbier11309163nobbier
nonskier1235983nonskier
nooser65517823noos_er
nosher94616363n_osher
nowise9511073nowise_
nubbier11308133nubbier
nurser64314503nurs_er
nuttier73112023nuttier
onerier7311613one_rier
osier53518013__osier
pawkier16236613pawkier
peakier134411443peakier
peatier94017233peatier
peckier153910523peckier
penster92811953penster
peppier10268323peppier
perkier133813123perkier
peskier13319113peskier
pester84827593pe_ster
pestier94317403pestier
pettier94213613pettier
pewter114013673pew_ter
prosier93817483prosier
pursier94012753pursier
pussier93711993pussier
queasier1734473queasier
readier83117423readier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
replier94214973replier
resider84615803re_sider
rester63832433re_ster
reviser104114663reviser
rewire95421403rew_ire
rewriter1137923rewriter
rosier64221263_rosier
rowdier11348593rowdier
sassier73413233sassier
seamier93114633seamier
sedgier9399043sedgier
seedier83513633seedier
seepier92912013seepier
seiser65318343seis_er
sewer84426213sew__er
sexier13310683se_xier
sissier73711363sissier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
snowier1038783snow_ier
sonsier7711743sonsier
sudsier868773sudsier
tarsier74119253tarsier
tawnier10318463tawnier
tearier73815613tearier
teaser65421523teas_er
techier1269243techier
teenier72611143teenier
teensier835573teensier
tenser64919433tens_er
tentier73815923tentier
terrier73414963terrier
terser67317823ters_er
tester64227153te_ster
testier74015643testier
thewier1336063thew_ier
tipsier9268893tipsier
tressier847963tressier
twier84713293_tw_ier
unwiser1037123unwiser
vealier102712173vealier
veinier10269583veinier
verier94620963ve_rier
vernier102711273vernier
verser94516963vers_er
vesper1138083ve_sper
viewier1334983view_ier
wearier103613283wearier
webbier1445423webbier
webster1236093webster
wedgier12428273wedgier
weedier113810623weedier
weenier103210803weenier
weensier1134243weensier
weepier12319273weepier
welsher13377443welsher
wennier10318603wennier
wester94222893we_ster
wiser85522803__wiser
wowser125110203wows_er
wrier84521753__wrier
wussier10408083wussier
yeastier1135393yeastier
yester93417983ye_ster
zester153617793ze_ster
zestier163010223zestier

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 Limit1340272948.56315651.9
3Display Results2942940.1062773.6
 (SQL Overall)1786912948.82520248.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.