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

118 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
biggity143501(None) 
biggety1434431biggety
baggily1436042baggily
biggie103810932biggi_e
biggies113813522biggies
biggin103710602biggi_n
bigging122815882bigging
biggins113410692biggins
biggish14247502biggish
biggy124413132bigg__y
dignity1236452dignity
ability12311443abi_lity
agility1148653agility
ambiguity1752083ambiguity
baggie102912193baggi_e
baggier113611643baggier
baggies113814853baggies
bagging123316983bagging
baggy125615683bagg__y
beggary14316153beggary
begging123012653begging
benignity1542813benignity
bifidity1743703bifidity
bigamy1436343bi_gamy
bigeminy1642903bigeminy
bigger104315063bigg_er
biggest1138143biggest
biggings13327473biggings
bight118728843bi_ght_
bights124417963bi_ghts
bigly114814753bi_g_ly
bigot84828323bi_got_
bigotry1344523bigotry
bigots95015133bi_gots
bigtime1235753bigtime
bigwig1333343bigwi_g
bigwigs1443003bigwigs
bilgier10358533bilgier
bilging114212683bilging
bilgy114713713bilg__y
binging113619383binging
binit76431583bi_nit_
binits85716673bi_nits
biogeny1336023biogeny
biotite9311033biotite
biparty1445583biparty
biscuity1543763biscuity
bitty106119173bi__tty
blighty16356843blighty
boggier113711583boggier
bogging123615753bogging
boggish14238653boggish
boggy126116073bogg__y
brevity1534783brevity
buggery14367933buggery
buggier113611343buggier
buggies114613813buggies
bugging123515183bugging
buggy124613483bugg__y
digging113513703digging
digit73825273di_git_
digits84114533di_gits
dignify1543893dignify
dimity12310473di_mity
dingily1238103dingily
eighty133711603ei_ghty
exiguity1942723exiguity
faggoty1542863faggoty
fidgety15384893fidgety
figging133313563figging
fixity19427803fi_xity
foggily1535053foggily
fuggily1534963fuggily
gigging93311773gigging
giggly12518703gigg_ly
igging93212073_igging
ignify1334513_ignify
ignite71410583_ignite
jiggier16377823jiggier
jigging173011553jigging
jiggish19225943jiggish
jiggly18378713jigg_ly
jiggy17549143jigg__y
lignify1443793lignify
lignite81310303lignite
maggoty1444013maggoty
mighty154310213mi_ghty
muggily1435103muggily
niggly11418913nigg_ly
nighty135611273ni_ghty
nigrify1444133nigrify
nuggety1234313nuggety
piggery14266193piggery
piggie103210773piggi_e
piggier113510003piggier
piggies113813483piggies
piggin103111093piggi_n
pigging123614673pigging
piggins113010473piggins
piggish14227703piggish
piggy124011433pigg__y
pigsty1235933pi_gsty
piosity1268643piosity
rigging103016333rigging
righty135011833ri_ghty
rigidity1345253rigidity
ringgit946013ringgit_
ringgits1044193ringgits
signify1444853signify
soggily1235953soggily
ubiquity2243073ubiquity
viduity1445343viduity
wiggery15295873wiggery
wiggier12418863wiggier
wigging133413833wigging
wiggly14559683wigg_ly
wiggy134510733wigg__y
zigging193210533zigging

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271185.86022871.5
3Display Results1181180.0333575.8
 (SQL Overall)1786911186.28328440.4
 
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.