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 “denier” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
denier7442069(None) 
defier105118651defier
denied84318631denied
deniers84515181deniers
denies74729641denies
denser74115191denser
dernier83011941dernier
dewier104013461dewier
aerier64823152aerier
belier84423562belier
bender95223302bender
bendier103111412bendier
bonier84321992bonier
censer84516582censer
center84421412center
dancer94817612dancer
dander811222992dander
dandier93714572dandier
danger83722822danger
danker114319662danker
deader84220472deader
deafer104114812deafer
deair65817192deai_r
dealer74122142dealer
dearer74822802dearer
decider114213182decider
decker135215992decker
decrier102713552decrier
deedier93011592deedier
deeper93613502deeper
deer56739022de__er
defer94619752de_fer
deffer134411302deffer
defied115016382defied
defiers113913992defiers
defies104624052defies
defiler113911882defiler
definer114413772definer
defter104215922defter
deicer94114412deicer
deifier113013122deifier
deliver113312242deliver
delver104913492delver
demies94825802demies
denar65223292den_ar
dene56643412den_e_
denes65639722den_es
deni56929392deni__
denial74720512denial
denim85518842deni_m
denimed1159232denimed
denims95214322denims
denizen1737662denizen
denned84215632denned
dense65923502dense_
dented84120512dented
denuder9167602denuder
derider93214972derider
deriver114213912deriver
desire7415302desire
desirer8310782desirer
deter65028042de_ter
deviser114212392deviser
dexie134716892dexie_
dexies145018342dexies
dexter143810892dexter
dicier94416232dicier
diner65632902din_er
dinger85323662dinger
dingier93513662dingier
dinkier123411502dinkier
dinner74217152dinner
dopier93515922dopier
dotier73917032dotier
downier11299702downier
dozier163611632dozier
drier64423962d_rier
dungier9368582dungier
dunker113616462dunker
dunner73913822dunner
edgier8469722edgier
eelier64216462eelier
eerier64320022eerier
ender64325862_ender
enter54726382_enter
envier939672_envier
fencer114613532fencer
fender103718722fender
fennier10339252fennier
fernier103110812fernier
gender83517932gender
genie66124922genie_
genies75324942genies
lender73921272lender
levier94013872levier
linier64423782linier
lunier64617602lunier
mender93520792mender
metier83517692metier
panier84425502panier
penner84616662penner
pinier84024692pinier
punier84519222punier
relier65826182relier
render74024142render
renter64527412renter
rentier73618222rentier
seiner64622482seiner
sender73824412sender
senior63214042senior
sexier13310682sexier
teenier72611142teenier
tender74121842tender
tenner64117102tenner
tenser64919432tenser
tenter64623932tenter
tentier73815922tentier
tinier63622232tinier
tonier65520712tonier
veiner94514752veiner
veinier10269582veinier
vender103418422vender
veneer94511692veneer
venire93513692venire
venter94218722venter
verier94620962verier
vernier102711272vernier
vinier93716742vinier
wanier93920682wanier
weenier103210802weenier
weiner94214132weiner
wennier10318602wennier
winier94522452winier
zanier154314712zanier

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511342.89028564.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911343.04658664.1
 
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.