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

363 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
newsies10131038(None) 
newbies12147421newbies
newies91014071new_ies
newsie9138211newsie_
newsier10147221newsier
newsiest11107481newsiest
easies64126632_easies
kewpies16246922kewpies
kneesies1245542kneesies
lewises1039132lewises
neddies92710702neddies
nellies73418722nellies
nesses64718322ne_sses
newbie11135412newbie_
newie81813482new_ie_
newsdesk1641732newsdesk
newsiness1236032newsiness
newsless1134532newsless
newsmen1235892newsmen
newswires1542612newswires
aegises8311373aegises
aeries64737783ae_ries
anergies9310453anergies
bawdies134613393bawdies
bawties124214313bawties
beanies93821093beanies
beasties102514653beasties
bedsides1246533bedsides
bedsits1037563bedsits
beedies10314203beedies
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
berries94423553berries
beses75830723be_s_es
besides104814533be_sides
betises94816123betises
bevies114017303be_vies
bewails1277553bewails
bewares12313373bewares
bewigs1246533bew_igs
bossies94116833bossies
bowses115718863bows_es
brewises1337213brewises
brewskies18132273brewskies
busies85525263_busies
ceases84427073ceas_es
censes83721803cens_es
cerises94722253cerises
cesses84221363ce_sses
cissies94116153cissies
cosies84932153_cosies
cowpies143314283cowpies
cowries124218013cowries
daisies84217093daisies
dassies84418663dassies
dawties113312703dawties
dearies83526273dearies
deashes113313903deashes
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
dellies83622213dellies
demies94825803de_mies
demises103719563demises
denies74729643de_nies
depsides1238503depsides
derbies103016053derbies
derries83124623derries
desires81316133de_sires
devises114116763devises
dewaxes18297843dewaxes
dewier104013463dew_ier
dewiest11312343dew_iest
dexies145018343de_xies
dowdies123412733dowdies
dowries114413983dowries
dowses105718303dows_es
eases56041613_eas_es
easier64218463_easier
easiest72318773_easiest
eddies83313163_eddies
egises7312493_egises
enemies9313693enemies
energies9310783energies
enisles72312603enisles
enosis63816423enosi_s
enosises8311003enosises
ensiles72714833_ensiles
enskies1138573enskies
ensues63313813_ensues
entries71523163entries
envies9314053_envies
eosines73718293_eosines
eosins64419163_eosins
erses55826803_ers_es
eses45336103_e_s_es
esnes54817363_e_snes
espies83716803_espies
esses56422973_e_sses
ewes76328703_ew__es
eyries93816813_eyries
falsies103515013falsies
feases95422923feas_es
fellies104119743fellies
felsites1138073felsites
ferlies103216693ferlies
ferries103521083ferries
fesses94820253fe_sses
gawkies15429123gawkies
gawsie1038463gawsie_
genies75324943ge_nies
gessoes838293gessoes
gestes75721393ge_stes
gipsies1039903gipsies
gneisses933673gneisses
gussies82813303gussies
gypsies1335953gypsies
hawkies173311243hawkies
hawses125113993haws_es
heavies132713873heavies
heinies102514543heinies
henries102718283henries
heresies11312693heresies
herries104025073herries
hessites1138613hessites
hissies103915823hissies
howdies142911953howdies
hussies103213293hussies
jellies143816533jellies
jemmies18318333jemmies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jesses135215953je_sses
jetties143613123jetties
kebbies1537253kebbies
kellies113516853kellies
kelpies13289903kelpies
kerries113317913kerries
kewpie15465413kewpie_
lassies74420103lassies
leases65428113leas_es
leashes103514403leashes
lefties10312073lefties
lenses64620893lens_es
leses54930813le_s_es
lessees73510243lessees
levies93919863le_vies
lewis85315843lew_i_s
lewisites1244213lewisites
lezzies1536203lezzies
mealies92821933mealies
meanies93620743meanies
measles92412753measles
meinies92516073meinies
menses84222453mens_es
menshes12310453menshes
mercies113817563mercies
merises93421423merises
meshes115019443me_shes
mesnes85216213me_snes
messes84924343me_sses
messier93412923messier
messiest103112423messiest
missies93423983missies
nancies93516843nancies
nannies73015203nannies
nappies114613403nappies
nasties73520493nasties
navies95218623n_avies
navvies1335323navvies
nearsides1044513nearsides
neckties1445903neckties
needier84010623needier
neediest92611303neediest
needles83211563needles
negates83215843negates
negliges1034833negliges
neguses837933neguses
neifs85613043ne__ifs
nellie63614813nellie_
nelsons738003nelsons
nemeses948663nemeses
nemesis937373nemesi_s
nenes55329673ne__nes
nerdier83110353nerdier
nerdiest92511163nerdiest
nereides938503nereides
nereids838743nereids
nereis6315343nerei_s
nerves94216193ne_rves
nervier10298833nervier
nerviest11188833nerviest
nervines112310463nervines
ness45526563ne_s__s
nested74720063ne_sted
nester64124183ne_ster
nesters74422793ne_sters
nestles73015463nestles
nests55728003ne_s_ts
netsukes1242793netsukes
nettier74211813nettier
nettiest83112433nettiest
nettles73214083nettles
neumes83112623ne_umes
neurines8311193neurines
neves87021873ne__ves
newel86114133new__el
newels93710823new_els
newer85717463new__er
newest9314213new__est
newish1237903new_ish
newness1035703newness
newnesses1236123newnesses
news76127373new___s
newsbeat1343623newsbeat
newsbeats1442663newsbeats
newsboy1542493newsboy
newsboys1642313newsboys
newscast1343433newscast
newsdesks1751393newsdesks
newsgirl1251823newsgirl
newsgirls1351533newsgirls
newsman1245503newsman
newspeak1742563newspeak
newspeaks1842393newspeaks
newsreel1142863newsreel
newsreels1242353newsreels
newswire1442603newswire
newsy11489393news__y
newtons1036813newtons
newts86015283new__ts
nexuses1436743nexuses
nifties102612503nifties
ninnies73713613ninnies
niseis63512023n_iseis
nixies135313873n_ixies
noddies93512043noddies
noesis6311443noesi_s
noesises838503noesises
noises65021853nois_es
noisier759453noisier
noisiest839763noisiest
noogies82814583noogies
nookies113414963nookies
nooses65623643noos_es
noses55435643n_os_es
noshes96618233n_oshes
nosier63716323n_osier
nosiest73415673n_osiest
nouses64627163nous_es
nowise9511073nowise_
nudies75217093n_udies
nurses63919353nurs_es
nutsier7329253nutsier
nutsiest82710243nutsiest
palsies94420273palsies
pansies94521983pansies
patsies93919483patsies
peases85229473peas_es
peavies122213403peavies
peeries93623023peeries
peises84125043peis_es
penises9318193penises
pennies94218813pennies
pensees9311203pensees
pensils92811593pensils
peonies93620153peonies
pepsines1239883pepsines
pepsins11310433pepsins
perries93226603perries
perses85428063pers_es
pewees11311393pew_ees
pewits112810683pew_its
poesies93217403poesies
popsies112816463popsies
posies84431433_posies
potsies93019483potsies
pussies93615693pussies
readies83324713readies
redries83721713redries
reflies104418533reflies
refries104419733refries
reifies104218283reifies
relies65036423re_lies
remises93423483remises
replies94521043replies
rerises73525883rerises
resees63827483re_sees
reshes94124363re_shes
resides84523283re_sides
resids74219153re_sids
resiles74026543re_siles
resins64528773re_sins
resites74027793re_sites
resits64725563re_sits
resizes164216843re_sizes
reties65436193re_ties
retries74129073retries
reuses66025523reus_es
revises104220533revises
rewakes144614983rewakes
rewashes1447033rewashes
rewaxes173911333rewaxes
rewins95020823rew_ins
rewires104717113rewires
rewrites11311063rewrites
rowdies113112693rowdies
sassies74719263sassies
seasides938743seasides
seises64026713seis_es
seisins73614393seisins
selkies113513353selkies
semises93916553semises
senseis73310643senseis
senses63923943sens_es
sepses84515883seps_es
sepsis83011293sepsi_s
series64540973se_ries
serries73925353serries
sewages1139753sewages
sissies73716603sissies
sneeshes1136513sneeshes
tansies74521243tansies
tassies74918933tassies
tawnies102812503tawnies
tawpies12309873tawpies
tawses94913193taws_es
teases65426273teas_es
techies12513603techies
teddies92711283teddies
tekkies1035943tekkies
tellies73820503tellies
tennies73017973tennies
tenses64722553tens_es
terries73425633terries
testes65125823te_stes
towies93521193tow_ies
townies103113623townies
uneases73316263uneas_es
uneasier836963uneasier
uneasiest946563uneasiest
veeries102916893veeries
veggies1237553veggies
vegies104314273ve_gies
verses94223763vers_es
versines112213823versines
verstes104014283verstes
wearies103020223wearies
websites1335183websites
wedgies123910213wedgies
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
welshes13379093welshes
wises85633193__wises
wries85827743__wries
wussies103411083wussies
yeses85119323ye_s_es
yesses93615813ye_sses
yowies123913733yow_ies

Search took 7 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.393454684.5
2DLD Change Limit1340273636.07622058.4
3Display Results3633630.1402592.9
 (SQL Overall)1786913636.60927037.5
 
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.