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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
bigheads1514565(None) 
bighead14126651bighead_
airheads1246132airheads
beheads1338522b_eheads
bigheaded1743922bigheaded
billheads1564252billheads
bowheads1745372bowheads
eggheads1442922eggheads
jugheads2042922jugheads
pinheads14336242pinheads
pitheads14338142pitheads
acidheads1642653acidheads
airhead1136993airhead_
baldheads1644133baldheads
beads85429503b___eads
beglads11127263beg_lads
behead1239923b_ehead_
besteads11307113besteads
bields94110003bi__elds
bigarade1244753bigarade
bigarades1344133bigarades
bigeyes1335653big_eyes
bighorns1445243bighorns
bighted142810923bighted_
bights124417963bigh__ts
bigness1038193bigne_ss
billhead1464433billhead_
bioherms1544213bioherms
bipeds11458053bi_pe_ds
blueheads1544063blueheads
bogbeans1343453bogbeans
boheas114013213b_ohea_s
boltheads1545123boltheads
boneheads1545203boneheads
bowhead1636433bowhead_
breads95419203b__reads
bridgeheads1991323bridgeheads
bugbears1333693bugbears
bugseeds1242843bugseeds
bulkheads1963373bulkheads
bullheads1564283bullheads
buttheads1553903buttheads
catheads1438103catheads
coheads13289233_coheads
dickheads2043633dickheads
egghead1343433egghead_
fatheads1536763fatheads
giltheads1443123giltheads
godheads1443983godheads
heads95127113___heads
highlands17114103highlands
highroads1743363highroads
highways2144113highways
hogsheads1773663hogsheads
hopheads17276603hopheads
hotheads15318013hotheads
jarheads1944793jarheads
jihads1734483ji_h_ads
jughead1933643jughead_
lipreads1144223lipreads
longheads1444233longheads
mishears1338323mishears
misleads11358543misleads
misreads11268923misreads
nailheads1343653nailheads
nighed113811293nighe_d_
pigheaded1743813pigheaded
pigweeds1553143pigweeds
pinhead13347073pinhead_
pithead13419593pithead_
potheads14298543potheads
railheads1343973railheads
redheads1336173redheads
sapheads1466083sapheads
shitheads1645043shitheads
sighed113712053sighe_d_
sighers113712173sighe_rs
skinheads1742813skinheads
subheads1496533subheads
tightwads1742823tightwads
towheads1544813towheads
warheads1545853warheads

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit146162828.03018202.0
3Display Results82820.0302733.3
 (SQL Overall)178691828.23321704.2
 
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.