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

177 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
bonded10471995(None) 
banded105223171banded
bended105521231bended
boded95124961bo_ded
bonder95324781bonder
boned85133241bon_ed
bonged105719601bonged
bonked135517311bonked
bounded113613761bounded
fonded115717041fonded
ponded105218771ponded
aboded104912512abo_ded
abounded1234902abounded
balded105417512balded
bander93928222bander
bandied114414302bandied
baned85436352ban_ed
banged104923722banged
banked135021442banked
banned94721342banned
barded105426422barded
beaded104922422beaded
bedded115114062bedded
bendee94121022bendee
bender95223302bender
bided95424962b_ided
binder94422872binder
binged105920822binged
binned94414542binned
birded104414302birded
bladed104717762bladed
blended114710712blended
blinded114810022blinded
blonde94813292blonde_
blonder104011942blonder
blondes104213162blondes
blooded11379802blooded
boarded113910502boarded
boated94221972boated
bobbed104315832bobbed
bode75838752bo_de_
bodes84935102bo_des
bodied103814582bodied
boffed15369482boffed
bogged116019282bogged
boiled95020952boiled
boinked14457042boinked
bolder94820932bolder
bolled94722652bolled
bolted94617802bolted
bombed134113872bombed
bond75334362bon__d
bonders104120662bonders
bondmen1237892bondmen
bonds86126842bond_s
bonduc1136602bonduc
bone65949322bon_e_
boner75133082bon_er
bones76446532bon_es
boney105227312bon_ey
bonier84321992bonier
bonne75124712bonne_
bonnes85621452bonnes
bonnet85524632bonnet
bonze165119352bonze_
bonzer175313672bonzer
bonzes175116102bonzes
boobed114514872boobed
boodled113410932boodled
booed85127272bo_oed
booked135319502booked
boomed115318132boomed
booted94822732booted
boozed184813832boozed
bopped134413402bopped
bordel94514572bordel
border94419972border
bored85034302bo_red
borked135117292borked
bossed94816532bossed
bounced123610552bounced
bounden10389452bounden
bounder104215532bounder
boused95322882boused
bowed114533422bo_wed
bowled125018132bowled
bowsed125715972bowsed
boxed154318612bo_xed
branded114414102branded
brinded115112052brinded
bronzed19308212bronzed
brooded113510932brooded
budded113912332budded
bundled114011302bundled
bunged105218792bunged
bunked135118372bunked
bunted95219182bunted
codded114515302codded
coded95433182co_ded
coned86040052con_ed
conked135019112conked
conned95119702conned
corded105923352corded
donned85015742donned
ended74421262_ended
fended114216912fended
folded114212792folded
fonder104120062fonder
fondled12399422fondled
fondued12466362fondued
forded115020392forded
founded124011422founded
fronded12388862fronded
funded114413892funded
goaded94913712goaded
godded104811802godded
gonged97115912gonged
handed114919982handed
hondled123510652hondled
honed95332262hon_ed
honied104818392honied
honked144517912honked
hooded114616742hooded
horded115420482horded
hounded123311032hounded
konked104010582konked
landed84619242landed
loaded84616872loaded
loided83414022loided
longed87121372longed
lorded84916732lorded
mended104418682mended
minded103817832minded
molded104414082molded
monde85723142monde_
mondes94322352mondes
monied94319462monied
mounded113711982mounded
nodded94012122nodded
pended103819012pended
podded115012712podded
poinded11358972poinded
ponced114314812ponced
ponder94521692ponder
ponged105619352ponged
ponied94920702ponied
pounded114112792pounded
rended84524102rended
rinded84418982rinded
rodded93713702rodded
rondel73212642rondel
rounded93013502rounded
sanded84920612sanded
sended85121232sended
sodded94113302sodded
sonde64622832sonde_
sonder73623522sonder
sondes74922872sondes
sounded93214462sounded
tended83819482tended
toned65435342ton_ed
tonged86518902tonged
unbonded12299762unbonded
vended114416352vended
voided114011132voided
wended113616152wended
winded114918212winded
woaded115211602woaded
wonder103617812wonder
wonned104012062wonned
wonted103213282wonted
wooded114213682wooded
worded114316622worded
wounded12329762wounded
yonder103214132yonder
zoned154020262zon_ed
zonked20429472zonked

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.1061685764.2
2DLD Change Limit825511773.14326265.0
3Display Results1771770.0931903.2
 (SQL Overall)1786911773.34253468.3
 
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.