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

119 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
bound8481958(None) 
abound9239861abound
bond75334361bo_nd
bounds94415801bounds
bund75530661b_und
found94917841found
hound95016481hound
mound83918311mound
pound84417861pound
round64318431round
sound64420021sound
wound94414211wound
abounds10217082abounds
around72712412around
band76740902b_and
baud74928422bau_d
bend76435262b_end
bind76234512b_ind
bland85320452bland
blend85317452blend
blind86319322blind
blond85618372blond
blued84520322blued
blunt75525022blunt
board85523002board
bod67055542bo__d
boded95124962boded
bohunk1533742bohunk
boing84725552boing
boink115516332boink
bold75432812bo_ld
bonds86126842bo_nds
bone65949322bo_ne
boned85133242boned
bong75633412bo_ng
bonk105531712bo_nk
bonne75124712bonne
bonny105816622bonny
bonus75324322bonus
bony96732082bo_ny
booed85127272booed
boon67142172boon_
boons75031912boons
bored85034302bored
born67338412born_
borne77926792borne
bosun75113592bosun_
bosuns8439382bosuns
bough115719312bough
boule74828042boule
bounce104014832bounce
bounced123610552bounced
bouncy13409072bouncy
bounded113613762bounded
bounden10389452bounden
bounder104215532bounder
bounty113411072bounty
bourg84113842bourg
bourn75518482bourn
bourne83714092bourne
bourns84114062bourns
bouse75931852bouse
boused95322882boused
bousy104917842bousy
bout66353292bou_t
bouts75131312bouts
bovid111011622bovid
bowed114533422bowed
boxed154318612boxed
brand85124492brand
brung84613912brung
brunt75728752brunt
bud67041272b_u_d
bun56348142b_un_
buna64730722b_una
bunds85523542b_unds
bundt85824852b_undt
bung75730632b_ung
bunk105731352b_unk
bunn65023652b_unn
buns66243722b_uns
bunt65850852b_unt
burd75534262b_urd
could86517712could
count74932052count
fond86330952fo_nd
founds104814192founds
fount84727032fount
fund85624982_fund
gourd71011902gourd
ground82310272ground
hounds104413132hounds
inbound10115772inbound
jocund1633622jocund
loud55228042lou_d
maund85515442maund
mould86015752mould
mounds93915132mounds
mount74128062mount
noun45724182noun_
nouns56717312nouns
obtund945582obtund
oud47439072_ou_d
poind84217912poind
pond75530492po_nd
pounds93714382pounds
rebound1058582rebound
rotund737292rotund
rounds73615612rounds
sounds74616182sounds
stound7399902stound
swound10377632swound
unbound10158392unbound
upbound12134812upbound
would95513152would
wounds103811632wounds
yond86122312yo_nd
young977742young
zounds164310172zounds

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001191.76630464.3
3Display Results1191190.0333606.1
 (SQL Overall)1786911191.89294445.6
 
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.