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

197 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
bulbils1133833(None) 
bulbels11398011bulbels
bulbil10389571bulbil_
bulbuls11346781bulbuls
bilbies114712342bilbies
bubals103513842bu_bals
bubbies103913512bubbies
bulbel104510682bulbel_
bulbous1138292bulbous
bulbs96016932bulb__s
bulbul10348072bulbul_
bulkily16227122bulkily
bullies94121892bullies
bulls75629572bul__ls
busbies113011692busbies
fulfils1345722fulfils
abulias93210703abul_ias
babels105216723b_abels
babies106123653b_abies
babuls105413643b_abuls
bails75933523b__ails
balboas113710073balboas
baldies105317703baldies
balkily16266693balkily
ballies93725743ballies
balls76236413bal__ls
balmily14216463balmily
barbels114514433barbels
barbies114519593barbies
basils85717473b_asils
belies84631053bel_ies
bellies94023723bellies
bells76432163bel__ls
bewails1277553bewails
bezils1711310603b_ezils
bilabials1393653bilabials
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilb_os
billies93923503billies
bills75632863bil__ls
blains84516373b_lains
blips95615783b_l_ips
bliss75616913b_l_iss
blubs95818153blub__s
bluebill1243593bluebill
bluebills1343093bluebills
bobbies103714563bobbies
bobbins103410343bobbins
boils75427193b__oils
bolls75531313bol__ls
boobies113718203boobies
brails84621293b_rails
brasils9410973brasils
brazils1867753brazils
broils84114173b_roils
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
bubal94218213bu_bal_
bubale104014623bu_bale
bubales113513343bu_bales
bubalis11359903bu_balis
bubbas94110703bu_bbas
bubble94016593bu_bble
bubbles104315963bubbles
bubblies1166773bubblies
bubbly124110353bu_bbly
bubkes144612623bu_bkes
buboes104513993bu_boes
bubs86235503bu_b__s
bubus95115453bu_b_us
buddies113914353buddies
budgies115312513budgies
buggies114613813buggies
buhls105111803bu__hls
build84413353bu__ild
builds9378493bu__ilds
built74325923bu__ilt
bulb85626693bulb___
bulbar1039583bulb_ar
bulbed114312773bulb_ed
bulblet11311213bulblet
bulblets1255353bulblets
bulgers105215143bulgers
bulges95919323bul_ges
bulgier103911213bulgier
bulgiest112910943bulgiest
bulging113514213bulging
bulgurs10397113bulgurs
bulimias1254323bulimias
bulimics1443153bulimics
bulkier134111513bulkier
bulkiest143511263bulkiest
bulking143815123bulking
bulks115920613bul__ks
bull65634873bul__l_
bulla74620563bul__la
bullbats1255893bullbats
bullets93516393bullets
bullied104514813bullied
bullier94116433bullier
bulliest104314503bulliest
bulling104324793bulling
bullion91911033bullion
bullions101710043bullions
bullish12511193bullish
bullous9311663bullous
bully105124813bul__ly
bumble124216893bumb_le
bumbles134016843bumbles
bumkins15318013bumkins
bumpily1665653bumpily
bunnies94415003bunnies
buppies133011063buppies
burble104617703burb_le
burbles114916803burbles
burbly134311153burb_ly
burbots1168673burbots
burbs95423493burb__s
burdies104117563burdies
burials93612093burials
buries84633273bu_ries
burins84221893bu_rins
burlily1237713burlily
burls74228853bu__rls
burnies94017823burnies
busbars1138153busbars
busboys14325023busboys
busgirls1142653busgirls
bushels124110713bushels
bushily15268893bushily
busies85525263bu_sies
busily112211503bu_sily
buskins133310943buskins
bustics11810883bustics
buttals938503buttals
butties93217953butties
butyls1176753bu_tyls
cubbies133312883cubbies
cubics123810163cu_bics
cubits103714033cu_bits
cullies94419963cullies
cullis84115993culli_s
culls75425813cul__ls
cumbias13338963cumbias
dubbins12358803dubbins
dulias71212743dul_ias
dulls64523743dul__ls
flails94313003_flails
fulfil1246423fulfil_
fulfill1345023fulfill
fulfills1443653fulfills
fulls84623523ful__ls
fusils93912343fu_sils
fuzils18407963fu_zils
gerbils1037303gerbils
gullies84717313gullies
gulls65222983gul__ls
gumboils1343893gumboils
hubbies143211563hubbies
huipils1243533huipils
hulls84923563hul__ls
jubile152910263ju_bile
jubiles16289373ju_biles
jumbals18106533jumbals
lulls54119653lul__ls
mulls75124153mul__ls
nubbins11268023nubbins
nubias8310093nu_bias
nubile83212713nu_bile
nulls55019983nul__ls
outbids1098913outbids
pubis94616473pu_bi_s
publics13207143publics
pulis74225603pul_i_s
pulls74425053pul__ls
pulpily1436103pulpily
pulpits1137243pulpits
pupils10389913pu_pils
quails153412643qu_ails
qubits173710353qu_bits
rubbies114114113rubbies
rubels84112993ru_bels
rubies84420343ru_bies
rugbies10339353rugbies
sulfids1137293sulfids
sulkies114315763sulkies
sulkily14218113sulkily
sullies74122233sullies
tulips8137253tul_ips
tumbrils12255373tumbrils
turbits969233turbits
twibils1253113twibils
umbels104510593_umbels
upboils1184703_upboils
urbias839093_urbias

Search took 8 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 Filter1786911340270.453394461.4
2DLD Change Limit1340271976.80019709.9
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.32924381.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.