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

174 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
newbie1113541(None) 
newbies12147421newbies
newie81813481new_ie
newsie9138221newsie
kebbie1435812kebbie
kewpie15465412kewpie
nellie63614812nellie
newies91014072new_ies
newsier10147232newsier
newsies101310392newsies
aerie54634603ae_rie
barbie105018353barbie
bawbee132714233bawbee
bawtie113812143bawtie
beanie83618593beanie
beebee10313063beebee
belie75630383be_lie
bewail1189583bewail
beware11313713beware
bewig1138903bew_ig
boobie104015293boobie
cabbie122913353cabbie
cebid104314073ce_bid
corbie103618203corbie
cowpie133511513cowpie
cowrie113814283cowrie
dawtie103011093dawtie
dearie73319813dearie
debit85727853de_bit
debye1138903de_bye
derbies103016053derbies
dewier104013463dew_ier
dexie134716893de_xie
dobie84920333_dobie
doobie94712683doobie
dowie94721143dow_ie
eerie55228533_eerie
enable83318483enable
ewe66630983_ew__e
eyrie88117833_eyrie
feeble1138253feeble
feirie939553feirie
ferlie92814053ferlie
freebie1236043freebie
gawsie1038463gawsie
genie66124923ge_nie
gerbil938343gerbil
hawkie163810093hawkie
hebe96424703he_b_e
heinie92512663heinie
hempie132410563hempie
henbit111412003henbit
herbier1239593herbier
hewable15177823hewable
howdie13349733howdie
kebbies1537253kebbies
kelpie12308613kelpie
kewpies16246923kewpies
lambie103213673lambie
lewis85315843lew_is
lezzie1435333lezzie
mealie82519813mealie
meanie83718393meanie
meinie82614523meinie
nabe66029493n_ab_e
nabis76020583n_abis
nannie63713223nannie
nappie104112263nappie
neb57238623ne_b__
nebbish1444253nebbish
nebs66124983ne_b_s
nebule848753nebule
necktie1344373necktie
neddies92710703neddies
nee36657783ne___e
needier84010623needier
needle73310613needle
negate72915573negate
neglige934873neglige
neif75429493ne__if
nellies73418723nellies
nene45932063ne__ne
nerdier83110363nerdier
nereid7312933nereid
nereis6315343nereis
nerve86617373ne_rve
nervier10298843nervier
nervine102510633nervine
nestle63013953nestle
netlike11308913netlike
nettier74211813nettier
nettle64514583nettle
neume74414403ne_ume
neumic1036853neumic
neurine7311683neurine
neve76224833ne__ve
nevi75116423ne_vi_
nevoid1098803nevoid
new66237093new___
newborn1244283newborn
newel86114133new_el
newels93710823newels
newer85717463new_er
newest9314213newest
newish1237903newish
newly114610203new_ly
news76127373new__s
newsboy1542493newsboy
newsiest11107483newsiest
newsmen1235893newsmen
newswire1442603newswire
newsy11489393new_sy
newt76933743new__t
newton936983newton
newts86015283new_ts
ngwee9311073ngw_ee
nibble103713283nibble
nimbi94910313nimbi_
nimble103412943nimble
niobic1037243niobic
niobite937953niobite
nixie125114943n_ixie
nobbier11309163nobbier
nobble103814313nobble
noble74420993n_oble
noogie73612313noogie
nookie103712433nookie
nowise9511073nowise
nubbier11308133nubbier
nubbin10308293nubbin
nubble103813713nubble
nubia7311233n_ubia
nubile83212713n_ubile
nudie65118673n_udie
pebble1238003pebble
peerie83617893peerie
perdie94718513perdie
pewee10319973pew_ee
pewit104622793pew_it
rebbe9313163re_bbe
rebid85121363re_bid
retie55735303re_tie
rewake135218463rewake
rewin85623963rew_in
rewire95421413rewire
rewoke1339521223rewoke
rewore938030163rewore
rewove126420083rewove
rewrite10311143rewrite
selkie102811693selkie
sewable121911173sewable
sewage10310733sewage
tawie84819813taw_ie
tawpie11339143tawpie
techie11511723techie
tekkie934203tekkie
tentie62521183tentie
terbia8311153terbia
terbic10410963terbic
towie85821873tow_ie
townie93312303townie
veggie1136303veggie
vegie94614513ve_gie
verbid122311313verbid
verbile1249863verbile
webbier1445423webbier
wedgie11428373wedgie
weenie92612023weenie
weepie11258793weepie
wellie92814913wellie
yabbie13308663yabbie
yowie114616453yow_ie
zombie1937323zombie
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.373479064.3
2DLD Change Limit1127161745.48620546.1
3Display Results1741740.0602900.0
 (SQL Overall)1786911745.91930189.4
 
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.