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

93 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
airheads124613(None) 
airhead1136991airhead_
acidheads1642652acidheads
airheaded1443952airheaded
airsheds12274962airshe_ds
bigheads15145652bigheads
fairleads1343022fairleads
jarheads1944792jarheads
nailheads1343652nailheads
pinheads14336242pinheads
pitheads14338142pitheads
railheads1343972railheads
stairheads1442762stairheads
warheads1545852warheads
acidhead1542793acidhead_
ahead96817053a__head_
airbags1036293air_bags
airboats1047283airboats
airchecks2042673airchecks
aired66032923air_e_d_
airers64922313air_e_rs
airfields1342203airfields
airholes1138033airholes
airless73712043airle_ss
airplays1344533airplays
airshed11258533airshe_d_
airspeeds1242513airspeeds
airted74214503airte_d_
airthed11328303airthe_d_
airways1336243air_ways
allheals1143913allheals
already1144263alr_eady
altheas1038223althea_s
areas55935773a_r_ea_s
arhats9312973a_rh_ats
arrears738843a_rrears
arrowheads1751463arrowheads
baldheads1644133baldheads
beheads1338523_beheads
bighead14126653bighead_
billheads1564253billheads
bowheads1745373bowheads
breads95419203_br_eads
catheads1438123catheads
coheads13289233_coheads
dickheads2043633dickheads
dirhams13376313dirh_ams
dreads84115023_dr_eads
eggheads1442923eggheads
fairlead1243513fairlead_
fatheads1536763fatheads
foreheads1647033foreheads
gearheads1444083gearheads
giltheads1443123giltheads
godheads1443983godheads
hardheads1745773hardheads
hashheads1543393hashheads
heads95127113___heads
hopheads17276603hopheads
hotheads15318013hotheads
jarhead1835173jarhead_
jihads1734483ji_h_ads
jugheads2042923jugheads
lipreads1144223lipreads
mastheads1545243mastheads
mishears1338323mishears
misleads11358543misleads
misreads11268923misreads
nailhead1243983nailhead_
oreads73915773_or_eads
overheads16248933overheads
pinhead13347073pinhead_
pithead13419593pithead_
potheads14298543potheads
railhead1244183railhead_
reads64835273__r_eads
redheads1336173redheads
rereads81512293rer_eads
rheas84816953__rhea_s
riverheads1742743riverheads
sapheads1466083sapheads
shitheads1645043shitheads
skinheads1742813skinheads
soreheads1346073soreheads
spreads1039763spr_eads
stairhead1343323stairhead_
subheads1496533subheads
threads11419953thr_eads
towheads1544813towheads
trailheads1443063trailheads
treads74817923_tr_eads
warhead1436603warhead_
waterheads1744243waterheads

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 Filter1786911461620.406440125.6
2DLD Change Limit146162937.37619815.9
3Display Results93930.0303100.0
 (SQL Overall)178691937.81222873.9
 
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.