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

170 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
bonier8432199(None) 
bonder95324781bonder
boner75133081bon_er
bonnier94711311bonnier
bonzer175313671bonzer
boxier154311741boxier
tonier65520711tonier
babier103515562babier
bander93928222bander
banger94423632banger
banker124222732banker
banner84421502banner
banter84825332banter
barnier93213672barnier
belier84423562belier
bender95223302bender
bendier103111412bendier
bier65531822b__ier
binder94422872binder
biner75930692bin_er
binger94923442binger
blonder104011942blonder
blowier1248942blowier
boater84622092boater
bobber95016742bobber
bodied103814582bodied
bodies94524142bodies
boggier113711582boggier
bogie89524102bogie_
bogies94724312bogies
boiler84319272boiler
bolder94820932bolder
bolter83920752bolter
bomber125014652bomber
bonded104719952bonded
bonders104120662bonders
bone65949322bon_e_
boned85133242bon_ed
boners84825432bon_ers
bones76446532bon_es
boney105227312bon_ey
boneyer1237402boneyer
bonfire1287062bonfire
bonged105719602bonged
boniest93318992boniest
boning94223292boning
bonita8312942bonita
bonito8313432bonito
bonked135517312bonked
bonkers134015302bonkers
bonne75124712bonne_
bonnes85621452bonnes
bonnet85524632bonnet
bonnie85314852bonnie_
bonze165119352bonze_
bonzes175116102bonzes
booger94816552booger
booker124719192booker
boomer104618512boomer
boomier113312182boomier
boonies93422482boonies
boozer174815962boozer
boozier18349012boozier
bopper123813832bopper
border94419972border
borer75131272bo_rer
bosker123813652bosker
boskier13309172boskier
bossier93712422bossier
bother115218062bother
bouncer113811332bouncer
bouncier1236032bouncier
bounder104215532bounder
bouvier1277432bouvier
bower107328182bo_wer
bowler114217312bowler
bowyer14368922bowyer
boxer145016522bo_xer
brier74527402b_rier
briner84519042briner
brinier93613462brinier
bronzer18348492bronzer
bronzier1935632bronzier
brownier13226912brownier
bunker124519372bunker
bunter85020382bunter
burier84324652burier
busier85219722busier
coiner84323782coiner
confer114018682confer
conger95024272conger
conies84338592conies
conifer123212642conifer
conker124721552conker
conner84423962conner
copier103722892copier
cornier93017082cornier
cosier84423752cosier
cowier113616162cowier
cozier173315142cozier
denier74420692denier
dopier93515922dopier
dotier73917032dotier
downier11299702downier
dozier163611632dozier
ebonies9312882ebonies
fonder104120062fonder
foxier163910032foxier
fozier183710662fozier
goner66025152gon_er
gooier73516212gooier
goonier83612842goonier
gorier73719372gorier
hokier134214032hokier
holier94921622holier
homier116416992homier
honer85332092hon_er
honied104818392honied
honker134117462honker
hornier103012452hornier
hosier94219612hosier
ionizer162310122ionizer
joiner134114132joiner
jokier17618752jokier
linier64423782linier
logier75015732logier
loner55431032lon_er
longer75823192longer
loonier73312672loonier
lunier64617602lunier
monger94418332monger
monie75631652monie_
monied94319462monied
monies83233162monies
moniker1338672moniker
moonier93714102moonier
mopier103914782mopier
nosier63716322nosier
oozier153610252oozier
osier53518012_osier
panier84425502panier
phonier122710632phonier
pinier84024692pinier
pokier124914632pokier
ponder94521692ponder
ponied94920702ponied
ponies84833462ponies
pornier93413122pornier
poxier153812112poxier
punier84519222punier
ropier84118802ropier
rosier64221262rosier
sonder73623522sonder
sonsier7711742sonsier
stonier72013792stonier
tinier63622232tinier
toner55336242ton_er
tonger74719682tonger
tonner64819202tonner
vinier93716742vinier
wanier93920682wanier
winier94522452winier
wonder103617812wonder
wonkier1437422wonkier
wonner95114442wonner
yonder103214132yonder
yonker134110852yonker
zanier154314712zanier
zoner144520342zon_er
zooier153411232zooier

Search took 3 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 Limit825511702.67330883.3
3Display Results1701700.0463695.7
 (SQL Overall)1786911702.82963164.0
 
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.