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

164 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
bunns7471829(None) 
banns75321231banns
bunas75126571bunas
bunds85523541bunds
bungs85323861bungs
bunks115125081bunks
bunn65023651bunn_
bunny104715801bunny
buns66243721bu_ns
bunts75729801bunts
burns74926781burns
sunns55017351sunns
aunts55227632aunts
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
bans66555142b_ans
barns76335142barns
beans75734692beans
bends85628972bends
benes75536232benes
benne76521122benne
bennes86019012bennes
benni74715362benni
bennis84314802bennis
benny105217362benny
bens65945702b_ens
bents76033692bents
binds86627472binds
bines76946792bines
bins66548252b_ins
bints76130182bints
blunts84512892blunts
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonne75124712bonne
bonnes85621452bonnes
bonny105816622bonny
bonus75324322bonus
boons75031912boons
bounds94415802bounds
bourns84114062bourns
brans75437432brans
brens75823362brens
brins75533972brins
bruins86014952bruins
brunts85215452brunts
bubs86235502bu_bs
bubus95115452bubus
bucks134824292bucks
buds75235172bu_ds
buffs135519512buffs
bugs76035912bu_gs
buhls105111802buhls
buhrs104811242buhrs
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bumfs125414052bumfs
bumps115921142bumps
bums85934592bu_ms
bun56348142bu_n_
buna64730722bu_na
bunch125118602bunch
bunco94616082bunco
buncos104011592buncos
bund75530662bu_nd
bundt85824852bundt
bundts95010842bundts
bung75730632bu_ng
bunions92210472bunions
bunk105731352bu_nk
bunko115514512bunko
bunkos124210322bunkos
bunnies94415002bunnies
bunt65850852bu_nt
bunya103810092bunya
bunyas11359432bunyas
buoys104810632buoys
burans85019302burans
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burins84221892burins
burls74228852burls
burn65636432burn_
burnt75230332burnt
burps94220172burps
burrs74925652burrs
burs65847422bu_rs
bus56950972bu__s
buses75936012buses
busks115521372busks
buss65134912bu_ss
busts75227692busts
butes714535872butes
buts67247692bu_ts
butts75824252butts
buys95726792bu_ys
conns75024232conns
cunts76125122cunts
curns74924282curns
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432du_ns
dunts65828412dunts
durns64819872durns
funds94119252funds
funks125318912funks
funny114614832funny
funs75235732fu_ns
guans64419442guans
gunks104517722gunks
gunny94413662gunny
guns55533482gu_ns
hunks125321452hunks
huns76136932hu_ns
hunts86826172hunts
inns46920932_inns
jinns126013842jinns
junks164815972junks
linns56123332linns
lunas55025012lunas
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
munis75022002munis
muns65535922mu_ns
muons75816172muons
nuns45228232nu_ns
punas74826752punas
pungs85422222pungs
punks114822682punks
punny104217712punny
puns66641482pu_ns
punts75828002punts
quins144819852quins
ruins55822032ruins
runes55530222runes
rungs611819402rungs
runny84613482runny
runs46438082ru_ns
runts55927632runts
sunn45423592sunn_
sunna55016062sunna
sunnas63914562sunnas
sunny84917742sunny
suns45841902su_ns
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tunny86515032tunny
tuns45138662tu_ns
turns55623242turns
uns35936762_u_ns
urns46323902_urns
wynns11517472wynns
yuans84613322yuans

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.313570897.8
2DLD Change Limit538001641.45337026.8
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.81298615.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.