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

103 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
bonzes17511610(None) 
bones76446531bon_es
bonnes85621451bonnes
bonze165119351bonze_
bonzer175313671bonzer
boozes174916521boozes
bronzes183510401bronzes
baizes174315052baizes
banes74945582ban_es
benes75536232ben_es
bennes86019012bennes
bines76946792bin_es
binges93923122binges
bizes165923662b_izes
bizzes163910842bizzes
blazes174817352blazes
blondes104213162blondes
bocces123912022bocces
boches134618522boches
bodes84935102bo_des
bodies94524142bodies
bogies94724312bogies
bogles95020832bogles
boites84322702boites
boles75448602bo_les
bombes124916822bombes
bonded104719952bonded
bonder95324782bonder
bonders104120662bonders
bonds86126842bon_ds
bone65949322bon_e_
boned85133242bon_ed
boner75133082bon_er
boners84825432boners
boney105227312bon_ey
bonged105719602bonged
bongoes104314112bongoes
bongos95316652bongos
bongs87828422bon_gs
bonier84321992bonier
boniest93318992boniest
bonked135517312bonked
bonkers134015302bonkers
bonks116326462bon_ks
bonne75124712bonne_
bonnet85524632bonnet
bonnets94812802bonnets
bonus75324322bon_us
bonuses94212952bonuses
boonies93422482boonies
booze164718912booze_
boozed184813832boozed
boozer174815962boozer
boozers183912442boozers
bores76448252bo_res
bortzes1838222bortzes
boshes114721882boshes
bosses85925402bosses
boules84925972boules
bounces113813682bounces
bouses84931782bouses
bowses115718862bowses
boxes145625072bo_xes
bozos165216862bo_zos
brazes175522192brazes
bronze173610922bronze_
bronzed19308212bronzed
bronzer18348492bronzer
bronzers19296982bronzers
buzzes165011172buzzes
cones76457422con_es
conges94928172conges
conies84338592conies
contes84432912contes
cozes166033242co_zes
cozzes164510892cozzes
donees74519492donees
donzel1636312donzel
donzels1735392donzels
dozes155226302do_zes
ebonies9312882ebonies
ebonizes1938072ebonizes
hones88144492hon_es
ionizes162813342ionizes
jones125028182jon_es
longes75925572longes
mondes94322352mondes
monies83233162monies
montes84226932montes
nonces84418832nonces
nones55639132non_es
ones46146532_on_es
oozes145418712_oozes
ponces104720842ponces
pones74547042pon_es
ponies84833462ponies
pontes83627852pontes
sondes74922872sondes
sones55444142son_es
tones56048662ton_es
tonnes65320852tonnes
winzes184313052winzes
zones145528042zon_es

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 Limit825511032.98327673.8
3Display Results1031030.0333121.2
 (SQL Overall)1786911033.12657162.8
 
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.