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 “bulbul” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

147 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
bulbul1034807(None) 
bulbel104510681bulbel
bulbil10389571bulbil
bulbuls11346781bulbuls
babul96317712b_abul
bubal94218212bu_bal
bubu85022672bu_bu_
bubus95115452bu_bus
bulb85626692bulb__
bulbar1039582bulbar
bulbed114312772bulbed
bulbels11398012bulbels
bulbils11338332bulbils
bulbous1138292bulbous
bulbs96016932bulb_s
bulgur9387532bulgur
bull65634872bul__l
album92312653_album
babel95821693b_abel
babu85829233b_abu_
babuls105413643b_abuls
babus95620333b_abus
bagful1237213bagful
balboa10389963balboa
baleful1238003baleful
ball66043323bal__l
barbal104016663barbal
barbel104317073barbel
barbule1137943barbule
barbut104617003barbut
bedbug12193973bedbug
befoul1137253befoul
belaud939133belaud
bell66237183bel__l
bilbo95513613bilb_o
bilboa10367843bilboa
bilbos105011203bilbos
bilby124912353bilb_y
bill67239943bil__l
billbug1242753billbug
blub85324873b_l_ub
blubs95818153blub_s
blue65328463b_l_ue
blur66020533b_l_ur
boll65634753bol__l
bolus79125543bol_us
bowlful1544613bowlful
boxful18145273boxful
bub76343983bu_b__
bubale104014623bu_bale
bubals103513843bu_bals
bubba84311803bu_bba
bubbas94110703bubbas
bubble94016593bubble
bubbly124110353bubbly
bubby115013933bu_bby
bubo85621913bu_b_o
bubs86235503bu_b_s
buccal1248243buccal
bugout9311863bugout
buhl95518223bu__hl
buildup1242333buildup
bulblet11311213bulblet
bulbously1643853bulbously
bulge86419873bul_ge
bulged105117123bulged
bulger94917353bulger
bulges95919323bulges
bulghur1352723bulghur
bulgurs10397113bulgurs
bulgy115214103bul_gy
bulk105426153bul__k
bulked134216743bulked
bulkily16227123bulkily
bulks115920613bul_ks
bulky146215573bul_ky
bulla74620563bul_la
bullae83416163bullae
bullbat1158553bullbat
bulled94626493bulled
bullet84528613bullet
bullous9311663bullous
bulls75629573bul_ls
bully105124813bul_ly
bulrush1243593bulrush
bumble124216893bumble
bunkum1435983bunkum
bupkus14385683bupkus
burb85334673burb__
burble104617703burble
burbly134311153burbly
burbot10815653burbot
burbs95423493burb_s
burial84117623burial
burl64937183bu__rl
bursal84414823bursal
busbar1038453busbar
busboy13307443busboy
busby126113293busb_y
bushel114513943bushel
butut75522913bu_tut
butyl1089103bu_tyl
buyout11310103buyout
cull65929643cul__l
cultus85110733cultus
cupful1356423cupful
dull56430443dul__l
fulfil1246423fulfil
full75229153ful__l
gull54828453gul__l
hubbub1243603hubbub
hull75428783hul__l
humbug1434803humbug
jugful1734603jugful
jumbal1758463jumbal
kultur1034433kultur
lull44225763lul__l
lulu44122883lul_u_
lulus54315163lul_us
mudbug1243253mudbug
mugful1235403mugful
mull65128803mul__l
null45125313nul__l
outbulk1336003outbulk
outbuy1146943outbuy
pull64731663pul__l
pullup1045893pullup
pulpal10408453pulpal
pulque1736213pulque
rubel75416833ru_bel
rubus76415063ru_bus
rueful948203rueful
soulful1045293soulful
sulcal8311273sulcal
sulcus8410493sulcus
sulfur937913sulfur
sulu45128423sul_u_
sulus54821883sul_us
tubal75517203tu_bal
tubful1136683tubful
tubule839853tu_bule
ulu36028703_ul_u_
ulus45622563_ul_us
umbel93612843_umbel
vulgus1035783vulgus
vulval12417663vulval
wilful1235963wilful

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161476.42317548.8
3Display Results1471470.0463195.7
 (SQL Overall)1786911476.84526105.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.