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

154 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
bulbs9601693(None) 
blubs95818151blubs
bubs86235491bu_bs
bulb85626691bulb_
bulks115920611bulks
bulls75629571bulls
burbs95423491burbs
albs68628572_albs
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
barbs95928192barbs
baulks12429372baulks
bells76432162bells
bels66142492bel_s
belts75931162belts
bibbs84911572bibbs
bibs84830972b_ibs
bilbo95513602bilbo
bilbos105011192bilbos
bilby124912342bilby
biles75542142biles
bilks115117892bilks
bills75632862bills
blabs95619632blabs
blebs96416152blebs
blobs95620032blobs
blub85324872blub_
blues75127042blues
blurbs10489312blurbs
blurs74619082blurs
bobs86340642b_obs
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bombs115818822bombs
boobs96221992boobs
boules84925972boules
bub76343972bu_b_
bubba84311792bubba
bubbas94110702bubbas
bubby115013922bubby
bubo85621902bu_bo
bubu85022662bu_bu
bubus95115452bubus
bucks134824292bucks
buds75235172bu_ds
buffs135519512buffs
bugles94822442bugles
bugs76035912bu_gs
buhls105111802buhls
buhrs104811242buhrs
builds9378492builds
bulbar1039582bulbar
bulbed114312772bulbed
bulbel104510682bulbel
bulbels11398012bulbels
bulbil10389572bulbil
bulbils11338332bulbils
bulbous1138292bulbous
bulbul10348072bulbul
bulbuls11346782bulbuls
bulge86419872bulge
bulges95919322bulges
bulgy115214102bulgy
bulk105426152bul_k
bulky146215572bulky
bull65634872bul_l
bulla74620562bulla
bully105124812bully
bumfs125414052bumfs
bumps115921142bumps
bums85934592bu_ms
bunas75126572bunas
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bu_ns
bunts75729802bunts
buoys104810632buoys
buras74736292buras
burb85334672burb_
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bu_rs
bus56950972bu__s
busby126113292busby
buses75936012buses
busks115521372busks
buss65134912bu_ss
busts75227692busts
butes714535872butes
butles84423912butles
buts67247692bu_ts
butts75824252butts
buys95726792bu_ys
clubs95415102clubs
cubs85832382cu_bs
culls75425812culls
culms95314192culms
cults75022552cults
curbs94821652curbs
dubs78432192du_bs
dulls64523742dulls
dumbs105915752dumbs
flubs105515442flubs
fubs96328792fu_bs
fulls84623522fulls
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852gul_s
hubs96027142hu_bs
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
lulls54119652lulls
lulus54315162lulus
mules75034292mules
mulls75124152mulls
nubs65927142nu_bs
nulls55019982nulls
numbs94913092numbs
pubs85029212pu_bs
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
rubs66133492ru_bs
rules55234252rules
slubs74719532slubs
subs66037122su_bs
sulks94818462sulks
sulus54821882sulus
tubs65430062tu_bs
tules54532792tules
ulus45622562_ulus
urbs65922052_urbs
yules84521582yules

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 Limit538001541.53335094.6
3Display Results1541540.0463347.8
 (SQL Overall)1786911541.672106872.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.