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

196 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
bolus7912554(None) 
bogus85616471bogus
bolas74733761bolas
bolds85825281bolds
boles75448601boles
bolls75531311bolls
bolos75531371bolos
bolts76232111bolts
bonus75324321bonus
obolus8378811obolus
solus54726981solus
tolus55024481tolus
babus95620332babus
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
beaus75127112beaus
bells76432162bells
bels66142492bel_s
belts75931162belts
biles75542142biles
bilks115117892bilks
bills75632862bills
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blots75626172blots
blouse84714722blouse
blousy11459122blousy
blows105423832blows
blub85324872b_lub
blubs95818152b_lubs
blue65328462b_lue
blues75127042b_lues
blur66020532b_lur
blurs74619082b_lurs
blush105115312b_lush
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
bogles95020832bogles
bogs75742752bo_gs
bohos105618252bohos
boils75427192boils
bola66035562bol_a
bolar75123472bolar
bold75432812bol_d
bole66448692bol_e
boletus948642boletus
boll65634752bol_l
bolo65535952bol_o
bolt66254172bol_t
boluses94113832boluses
bombs115818822bombs
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
bosun75113592bosun
bosuns8439382bosuns
botas75328782botas
bots66453952bo_ts
botts75224862botts
boule74828042boule
boules84925972boules
bouse75931852bo_use
bousy104917842bo_usy
bout66353292bo_ut
bouts75131312bouts
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boylas113011722boylas
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
bubus95115452bubus
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bus56950972b__us
colas75436772colas
colds85726972colds
coles76055062coles
coleus86818272coleus
cols66553082col_s
colts76633292colts
conus76726532conus
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
embolus1135542embolus
flus75626542_flus
focus105815882focus
folds95221692folds
folks126017122folks
fouls87221432fouls
golds75421312golds
golfs95616102golfs
hilus84817642hilus
hocus104715202hocus
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
iglus6609932iglus
joles125230832joles
jolts125018882jolts
kolas94822232kolas
kolos94921212kolos
locus74819992locus
lolls512121732lolls
lotus55718062lotus
lulus54315162lulus
modus85417202modus
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
momus96116112momus
nodus66315992nodus
nolos54423352nolos
nous46136982no_us
obelus8348402obelus
oboles83815832oboles
obols73715862obol_s
olds55926572_olds
oles46453472_oles
onus45826812_onus
opus66420592_opus
pilus75921062pilus
plus66324832_plus
poilus82210572poilus
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
soles55547922soles
soleus64615612soleus
solos54830792solos
sols45448162sol_s
solum74717612solum
solums85211332solums
sorus54527582sorus
souls55127362souls
sous46947212so_us
sulus54821882sulus
talus55423262talus
tofus86415422tofus
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolu45529152tolu_
tonus56324302tonus
torus54329762torus
ulus45622562_ulus
voles86234042voles
volts85421292volts
wolds95420182wolds
wolfs116214162wolfs
yolks125412772yolks
yous76230652yo_us

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.296603685.8
2DLD Change Limit538001961.53035163.4
3Display Results1961960.0633111.1
 (SQL Overall)1786911961.88994595.6
 
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.