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

242 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
warhead143660(None) 
jarhead1835171jarhead
warheads1545851warheads
ahead96817052_a_head
airhead1136992airhead
barehead1446602barehead
cathead1338752cathead
fathead1437862fathead
gearhead1344432gearhead
hardhead1645882hardhead
jarheads1944792jarheads
saphead1357772saphead
warded115021042warde_d
wared96339872war_e_d
warked144421212warke_d
warmed124516892warme_d
warned104018912warne_d
warped124816412warpe_d
warred104019842warre_d
warted104223232warte_d
washed135521502washe_d
waterhead1644392waterhead
aahed917816443_aahe_d
ached119227833_ache_d
ahed89536253_a_he_d
airheads1246133airheads
arced88224163_arce_d
archean1269123_archean
arched125717323_arche_d
area45843393_ar_ea_
areae55229743_ar_eae
areal55928733_ar_eal
areas55935773_ar_eas
arhat8327093_arh_at
armed86324433_arme_d
arrear6310253_arrear
ashed97829773_ashe_d
awarded1236223awarde_d
bached145519893bache_d
baldhead1544273baldhead
barbed115121313barbe_d
barded105426423barde_d
bared85144483bar_e_d
barehand1446153barehand
barfed125416383barfe_d
barged105822643barge_d
barked135027313barke_d
barned95623583barne_d
barred95725793barre_d
bartend1038753bartend
bashed126225703bashe_d
bathed125518743bathe_d
behead1239923_behead
bighead14126653bighead
bowhead1636433bowhead
bread85523113_br_ead
cached145419203cache_d
carded105424903carde_d
cared86050093car_e_d
caried94528693carie_d
carked134024823carke_d
carload1039783carload
carped115923763carpe_d
carted98631443carte_d
carved124320853carve_d
cashed125124353cashe_d
catheads1438123catheads
cohead123811123_cohead
dared75935013dar_e_d
darked123919633darke_d
darned85018483darne_d
darted84620923darte_d
dashed115920563dashe_d
deadhead1444433deadhead
dread74419023_dr_ead
dwarfed1533483dwarfe_d
eared65139503ear_e_d
earned74818333earne_d
earthed1139923earthe_d
egghead1343433egghead
fairlead1243513fairlead
farad95720673far__ad
farced125216533farce_d
farded114518953farde_d
fared95842343far_e_d
farmed125117653farme_d
farted105121783farte_d
fashed136720253fashe_d
fatheads1536763fatheads
flathead1535803flathead
forehead1537893forehead
garbed104815663garbe_d
garred85217403garre_d
gashed116321973gashe_d
gearheads1444083gearheads
godhead1334763godhead
hardheads1745773hardheads
hared95742183har_e_d
harked145422553harke_d
harmed125218833harme_d
harped124418403harpe_d
hashed136021943hashe_d
hashhead1443263hashhead
head87137173___head
hophead16337923hophead
hothead14349293hothead
jarred144613253jarre_d
jughead1933643jughead
larded84319093larde_d
larked114519473larke_d
lashed105625213lashe_d
lathed104718453lathe_d
marched153813403marche_d
marked133921623marke_d
marled95523163marle_d
marred95421043marre_d
marted94425213marte_d
mashed125325043mashe_d
masthead1435883masthead
meathead1436793meathead
nailhead1243983nailhead
narked114116743narke_d
oared65030653oar_e_d
oread64619603_or_ead
overhead152110363overhead
parched154013693parche_d
pared86946763par_e_d
parged104922043parge_d
parked134425143parke_d
parled94626293parle_d
parred95024073parre_d
parsed96323893parse_d
parted94228683parte_d
pashed125923143pashe_d
pinhead13347073pinhead
pithead13419593pithead
pothead133810393pothead
railhead1244183railhead
rared65738323rar_e_d
read55942533__r_ead
redhead1257053redhead
reread71715433rer_ead
rhea75017433__rhea_
rheas84816953__rheas
sapheads1466083sapheads
sashed105622943sashe_d
scarehead1543803scarehead
sorehead1246973sorehead
spearhead1542983spearhead
spread9312533spr_ead
stairhead1343323stairhead
subhead1387693subhead
swanherd1533483swanherd
swarded1238153swarde_d
swarmed1367483swarme_d
swashed144311363swashe_d
swathed144611933swathe_d
tared69340053tar_e_d
tarred74720283tarre_d
tarted74923373tarte_d
tarweed1137343tarweed
thread105011093thr_ead
towhead1435223towhead
tread64821703_tr_ead
unread73412673unr_ead
varied104817863varie_d
varved134110603varve_d
wadded124014173wadde_d
waded106024753wa_de_d
waffed16459793waffe_d
wafted134012143wafte_d
waged104822783wa_ge_d
wagged124616123wagge_d
waifed134011033waife_d
wailed104823593waile_d
waired106015833waire_d
waited103819773waite_d
waived134511283waive_d
waked135626753wa_ke_d
waled94330993wa_le_d
walked145313783walke_d
walled104021293walle_d
waned95831783wa_ne_d
wanked144517153wanke_d
wanned104318013wanne_d
wanted104319723wante_d
wapped144416473wappe_d
warbled133212163warbled
ward86542253war___d
warden104515513warde_n
wardens113711903wardens
warder104020273warde_r
warders113416813warders
ware76254723war_e__
wares88250583war_e_s
warier93722893warie_r
wariest105122503wariest
warless104015103warless
warlord1136293warlord
warmer113816733warme_r
warmers124514293warmers
warmest123113033warmest
warner93717223warne_r
warners103315563warners
warper114015583warpe_r
warpers123413583warpers
warren95012853warre_n
warrens103810893warrens
warsaw1236193war_saw
warsled112910443warsled
washday1743383washday
washer124720393washe_r
washers134517523washers
washes124425493washe_s
washrag1444043washrag
wasted104423023waste_d
watched163012823watche_d
waterheads1744243waterheads
wauked144210573wauke_d
wauled104713963waule_d
waved125223583wa_ve_d
wawled133811703wawle_d
waxed166018483wa_xe_d
waxweed2132923waxweed
wearied112911803wearie_d
wellhead1543503wellhead
wergeld1233183wergeld
wharfed1734413wharfe_d
wheal115716183w__heal
wheat114924573w__heat
wired95327643wir_e_d
wished134417513wishe_d
withed134416233withe_d
worded114316623worde_d
worked145314703worke_d
wormed124314303worme_d
worthed1437873worthe_d
wrathed14298523wrathe_d
wreak125513273w_r_eak
wried95518563w_rie_d
yarded114714023yarde_d
yarned105514023yarne_d

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272427.92316916.2
3Display Results2422420.0763184.2
 (SQL Overall)1786912428.40521260.1
 
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.