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

189 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
jarhead183517(None) 
jarheads1944791jarheads
warhead1436601warhead
ahead96817052_a_head
airhead1136992airhead
barehead1446602barehead
cathead1338752cathead
fathead1437862fathead
gearhead1344432gearhead
hardhead1645882hardhead
jarred144613252jarre_d
jughead1933642jughead
saphead1357772saphead
warheads1545852warheads
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
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
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
jabbed184213483jabbe_d
jacked204817523jacke_d
jaded144417033ja_de_d
jagged164115353jagge_d
jailed144917423jaile_d
jambeau1843773jambeau
jambed184811403jambe_d
jammed183811503jamme_d
japed156217633ja_pe_d
jarina134014063jarina_
jarinas143712183jarinas
jarrah1636683jar_rah
jarvey19135403jarve_y
jarveys20123413jarveys
jauked18489013jauke_d
jauped16457903jaupe_d
jawed165517373ja_we_d
jazzed22416293jazze_d
jehad1637683j_eh_ad
jereed144012073jer_eed
jerked18479593jerke_d
jerreed1535213jerreed
jetbead1742983jetbead
jihad1635913j_ih_ad
joshed174610903joshe_d
jugheads2042923jugheads
juried144212443jurie_d
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
tared69340053tar_e_d
tarred74720283tarre_d
tarted74923373tarte_d
tarweed1137343tarweed
thread105011093thr_ead
towhead1435223towhead
tread64821703_tr_ead
unread73412673unr_ead
varied104817863varie_d
varved134110603varve_d
warded115021043warde_d
wared96339873war_e_d
warked144421213warke_d
warmed124516893warme_d
warned104018913warne_d
warped124816413warpe_d
warred104019843warre_d
warted104223233warte_d
washed135521503washe_d
waterhead1644393waterhead
yarded114714023yarde_d
yarned105514023yarne_d

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.406440125.6
2DLD Change Limit1340271896.03022226.7
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.49927495.2
 
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.