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

263 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
newbies1214742(None) 
newbie11135411newbie_
newies91014071new_ies
newsies101310381newsies
derbies103016052derbies
kebbies1537252kebbies
kewpies16246922kewpies
neddies92710702neddies
nellies73418722nellies
newie81813482new_ie_
newsie9138212newsie_
newsier10147222newsier
newsiest11107482newsiest
aeries64737783ae_ries
alibies9313323alibies
anergies9310453anergies
babies106123653_babies
barbies114519593barbies
bawbees14337243bawbees
bawdies134613393bawdies
bawties124214313bawties
beanies93821093beanies
beebees1138013beebees
beedies10314203beedies
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
berries94423553berries
bevies114017303be_vies
bewails1277553bewails
bewares12313373bewares
bewigs1246533bew_igs
bilbies114712343bilbies
bobbies103714563bobbies
boobies113718203boobies
bubbies103913513bubbies
busbies113011693busbies
cabbies133115163cabbies
cebids11439173ce_bids
corbies113520123corbies
cowpies143314283cowpies
cowries124218013cowries
cubbies133312883cubbies
darbies104216983darbies
dawties113312703dawties
dearies83526273dearies
debits94214503de_bits
debyes1238103de_byes
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
dellies83622213dellies
demies94825803de_mies
denies74729643de_nies
derries83124623derries
dewaxes18297843dewaxes
dewier104013463dew_ier
dewiest11312343dew_iest
dexies145018343de_xies
dobbies124113063dobbies
dobies94422093_dobies
doobies103915673doobies
dowdies123412733dowdies
dowries114413983dowries
easies64126633_easies
eddies83313163_eddies
enables92813123enables
enemies9313693enemies
energies9310783energies
enskies1138573enskies
entries71523163entries
envies9314053_envies
espies83716803_espies
ewes76328703_ew__es
eyries93816813_eyries
fellies104119743fellies
ferlies103216693ferlies
ferries103521083ferries
freebies1337873freebies
gabies93820733_gabies
gawkies15429123gawkies
genies75324943ge_nies
gerbils1037303gerbils
gobies95418063_gobies
hawkies173311243hawkies
heavies132713873heavies
hebes105521673he_b_es
heinies102514543heinies
henbits12177003henbits
henries102718283henries
herbier1239593herbier
herbiest1339993herbiest
herries104025073herries
hobbies143813343hobbies
howdies142911953howdies
hubbies143211563hubbies
jellies143816533jellies
jemmies18318333jemmies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
kebbie1435813kebbie_
kellies113516853kellies
kelpies13289903kelpies
kerries113317913kerries
kewpie15465413kewpie_
kneesies1245543kneesies
lambies113015113lambies
lefties10312073lefties
levies93919863le_vies
lewis85315843lew_i_s
lewises1039133lewises
lezzies1536203lezzies
lobbies113612463lobbies
loobies93814103loobies
mealies92821933mealies
meanies93620743meanies
meinies92516073meinies
mercies113817563mercies
nabes75427093n_ab_es
nabis76020583n_abi_s
nancies93516843nancies
nannies73015203nannies
nappies114613393nappies
nasties73520493nasties
navies95218623n_avies
navvies1335323navvies
nebbish1444253nebbish
nebbishes1642973nebbishes
nebs66124983ne_b__s
neckties1445903neckties
needier84010623needier
neediest92611303neediest
needles83211563needles
negates83215843negates
negliges1034833negliges
neguses837933neguses
neifs85613043ne__ifs
nellie63614813nellie_
nemeses948663nemeses
nenes55329673ne__nes
nerdier83110353nerdier
nerdiest92511163nerdiest
nereides938503nereides
nereids838743nereids
nereis6315343nerei_s
nerves94216193ne_rves
nervier10298833nervier
nerviest11188833nerviest
nervines112310463nervines
nesses64718323ne_sses
nestles73015463nestles
nettier74211813nettier
nettiest83112433nettiest
nettles73214083nettles
neumes83112623ne_umes
neurines8311193neurines
neves87021873ne__ves
newborn1244273newborn
newborns1343403newborns
newel86114133new__el
newels93710823new_els
newer85717463new__er
newest9314213new__est
newish1237903new_ish
newness1035703newness
news76127373new___s
newsboys1642313newsboys
newsdesk1641733newsdesk
newsiness1236033newsiness
newsless1134533newsless
newsmen1235893newsmen
newswires1542613newswires
newtons1036813newtons
newts86015283new__ts
nexuses1436743nexuses
nibbles114011693nibbles
nifties102612503nifties
ninnies73713613ninnies
niobites1037313niobites
nixies135313873n_ixies
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbles114014523nobbles
nobles83319723n_obles
noddies93512043noddies
nombles113212343nombles
noogies82814583noogies
nookies113414963nookies
nowise9511073now_ise
nubbier11308133nubbier
nubbiest12117313nubbiest
nubbins11268023nubbins
nubbles113412433nubbles
nubias8310093n_ubias
nudies75217093n_udies
numbles113814273numbles
peavies122213403peavies
pebbles1337573pebbles
peeries93623023peeries
pennies94218813pennies
peonies93620153peonies
perries93226603perries
pewees11311393pew_ees
pewits112810683pew_its
rabbies113416053rabbies
rabies85226023_rabies
readies83324713readies
rebbes10313533re_bbes
rebids94015533re_bids
redries83721713redries
reflies104418533reflies
refries104419733refries
reifies104218283reifies
relies65036423re_lies
replies94521043replies
reties65436193re_ties
retries74129073retries
rewakes144614983rewakes
rewaxes173911333rewaxes
rewins95020823rew_ins
rewires104717113rewires
rewrites11311063rewrites
rowdies113112693rowdies
rubbies114114113rubbies
rubies84420343_rubies
rugbies10339353rugbies
scabies11613333scabies
selkies113513353selkies
series64540973se_ries
serries73925353serries
sewages1139753sewages
tabbies112913503tabbies
tawnies102812503tawnies
tawpies12309873tawpies
techies12513603techies
teddies92711283teddies
tekkies1035943tekkies
tellies73820503tellies
tennies73017973tennies
terbias9310743terbias
terries73425633terries
tobies84521023_tobies
towies93521193tow_ies
townies103113623townies
veeries102916893veeries
veggies1237553veggies
vegies104314273ve_gies
verbids13259203verbids
verbiles1338923verbiles
wearies103020223wearies
webbier1445423webbier
webbiest1535353webbiest
wedgies123910203wedgies
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
wries85827743__wries
yabbies14279643yabbies
yowies123913733yow_ies
zombies2037993zombies

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272635.67023637.9
3Display Results2632630.1102390.9
 (SQL Overall)1786912635.92330169.0
 
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.