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

134 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
flathead153580(None) 
fathead1437861f_athead
flatheads1644871flatheads
cathead1338752_cathead
fatheads1536762f_atheads
flashed144112182flashe_d
flatbed13397982flatbe_d
flatbread1542292flatbread
flatted114012942flatte_d
flinthead1642302flinthead
lathed104718452_lathe_d
meathead1436792meathead
ahead96817053__a_head
alated75625143alat_e_d
althea938193al_thea_
altheas1038223al_theas
baldhead1544273baldhead
bathed125518743_bathe_d
blackhead2184293blackhead
blather125314203blathe_r
blathered15168353blathered
blathers134713793blathers
blatted104812713blatte_d
bluehead1444603bluehead
bolthead1445903bolthead
butthead1454513butthead
catheads1438123_catheads
clashed133614013clashe_d
clothed134010283clothe_d
clubhead1662773clubhead
deadhead1444433deadhead
elated74725823elat_e_d
faithed1437163faithe_d
fashed136720253f_ashe_d
fated95632133f_at_e_d
fatheaded1744273f_atheaded
father125116713f_athe_r
fathered151510433f_athered
fathers133916503f_athers
fatted105419843f_atte_d
feather133613503feathe_r
feathered16188893feathered
feathers143513243feathers
feathery17368073feathery
flacked173711583flacke_d
flagged13459633flagge_d
flailed1137303flaile_d
flaked144715653fla_ke_d
flambeau1543323flambeau
flambeed16324383flambeed
flamed124618973fla_me_d
flammed15377413flamme_d
flanged123810843flange_d
flanked153710643flanke_d
flapped15328253flappe_d
flared105317603fla_re_d
flashcard1842043flashcard
flasher133914063flashe_r
flashers143912653flashers
flashes133916103flashe_s
flatbeds14364543flatbeds
flatboat1346473flatboat
flatbreads1652243flatbreads
flatcap1463653flat_cap
flatcar1274613flat_car
flatfeet1446213flatfeet
flatland1264963flatland
flatlet10312253flatle_t
flatlets1147373flatlets
flatness1138153flatness
flatten10429653flatte_n
flattened13185303flattened
flattens11357483flattens
flatter103815963flatte_r
flattered13188623flattered
flatters113814203flatters
flattery14338293flattery
flattest1138713flattest
flawed134712723fla_we_d
flaxseed1942573flaxseed
flayed134414053fla_ye_d
fleshed143210263fleshe_d
fletched17306693fletche_d
flintheads1741983flintheads
flitched17256293flitche_d
flited104616583flit_e_d
flitted114011643flitte_d
floated113312703float_e_d
flushed143310973flushe_d
fluted104917163flut_e_d
flyted13378773flyt_e_d
forehead1537893forehead
frothed14288783frothe_d
gearhead1344433gearhead
gilthead1343323gilthead
goatherd1335263goatherd
hothead14349293_hothead
jarhead1835173_jarhead
lashed105625213_lashe_d
latched133914063_latche_d
lated65240673_lat_e_d
laterad8310843_laterad
lathe85626713_lathe__
lather95124353_lathe_r
lathered121512323_lathered
lathers104321883_lathers
lathery133911123_lathery
lathes95127493_lathe_s
lethean1037093_lethean
loathed11419443loathe_d
masthead1435883masthead
meatheads1545963meatheads
neatherd12107193neatherd
pithead13419593_pithead
plashed133712643plashe_d
plateau937403plat_eau
plated95225773plat_e_d
platted103614263platte_d
plowhead1742803plowhead
pothead133810393_pothead
saphead1357773_saphead
scathed134012643scathe_d
shithead1535523shithead
slashed114114853slashe_d
slated75028313slat_e_d
slather103816073slathe_r
slathered13148543slathered
slathers113914783slathers
slatted84015183slatte_d
softhead1545003softhead
spathed134013183spathe_d
swathed144611933swathe_d
warhead1436603_warhead
wrathed14298523wrathe_d

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.453394461.4
2DLD Change Limit1461621347.25020160.3
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.74923059.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.