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

126 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
blub8532487(None) 
blab86629131blab
bleb85425221bleb
blob86027091blob
blubs95818151blubs
blue65328461blue
blur66020531blur
blurb95214901blurb
bub76343971b_ub
bulb85626691bulb
club85819471club
flub95721881flub
slub65428031slub
alb57342652al_b
alum65227612alum
babu85829222babu
barb85240062barb
baud74928422baud
bhut95425712bhut
bib77045922b_ib
bibb75819192bibb
blabs95619632blabs
blae66134642blae
blah98625062blah
blam86131702blam
blat66550952blat
blaw97026722blaw
blebs96416152blebs
bled75729312bled
blet66247672blet
blew94722432blew
blin67228172blin
blip88322772blip
blobs95620032blobs
bloc85023272bloc
blog75723822blog
blot65842322blot
blow95827192blow
blued84520322blued
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
bluff134413832bluff
blume95619892blume
blunt75525022blunt
blurbs10489312blurbs
blurs74619082blurs
blurt77625622blurt
blush105115312blush
bob76755662b_ob
bolus79125542bolus
bomb106927422bomb
boob85932582boob
bout66353292bout
brut66537962brut
brux136315272brux
bubo85621902b_ubo
bubs86235492b_ubs
bubu85022662b_ubu
bud67041272b_ud
bug65340742b_ug
bulbs96016932bulbs
bulk105426152bulk
bull65634872bull
bum75342692b_um
bun56348142b_un
bur55744692b_ur
burb85334672burb
bus56950972b_us
but55963022b_ut
buy86436542b_uy
chub115516412chub
clubs95415102clubs
clue65324532clue
cub76940942_cub
daub77423442daub
drub75920132drub
dub66642202_dub
flab96628352flab
flu66530212flu_
flubs105515442flubs
flue75329852flue
flus75626542flus
flux145617742flux
fub86337392_fub
glib79421432glib
glob76623392glob
glue55628492glue
glug66118012glug
glum75825102glum
glut56331292glut
grub77220082grub
hub86437482_hub
lab58864782_lab
lib57750262_lib
lob57154462_lob
lube64731562_lube
lug46138062_lug
lum55542932_lum
luv67125772_luv
lux106528772_lux
nub56439142_nub
pleb86123812pleb
plug74915992plug
plum85122102plum
plumb114514072plumb
plus66324832plus
pub76037692_pub
rub56342822_rub
shlub105411742shlub
slab67133762slab
slob66029422slob
slubs74719532slubs
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slurb74116322slurb
slut45040592slut
snub65320762snub
stub66221842stub
sub55445552_sub
tub55640032_tub
ulu36028702ulu_
ulus45622562ulus

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 Filter178691298720.1401276364.3
2DLD Change Limit298721262.04614600.2
3Display Results1261260.0632000.0
 (SQL Overall)1786911262.24979453.5
 
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.